Issue Details (XML | Word | Printable)

Key: CORE-1339
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Adriano dos Santos Fernandes
Reporter: Jorge Andres Brugger
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Metadata charset upgrade script generates garbage in descriptions

Created: 02/Jul/07 01:05 PM   Updated: 29/Dec/07 05:28 AM
Component/s: Scripts
Affects Version/s: 2.1 Beta 1
Fix Version/s: 2.1 Beta 2

Time Tracking:
Not Specified

File Attachments: 1. Text File description_garbage.txt (32 kB)
2. File TEST21BETA.fbk (12 kB)

Environment: WinXP, Firebird 2.1 Beta1 using a fixed 2.0.1 Database restored with 2.1 gbak.
Issue Links:
Relate
 


 Description  « Hide
When executing steps described in misc/upgrade/metadata_charset.txt to fix character sets and metadata extraction problem, descriptions got messed up:

Before: "Descripci?n completa del producto." (2.01 DB)

After: "Descripci???????<long mess stripped>????????"
(2.1 with metadata fixed)


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Jorge Andres Brugger added a comment - 02/Jul/07 01:29 PM
Jira also have problems with charsets. Attached is a "before and after" applying fix script.

Adriano dos Santos Fernandes added a comment - 02/Jul/07 08:32 PM
Nothing can be done without a complete test-case.

Jorge Andres Brugger added a comment - 03/Jul/07 07:41 AM
This is a 2.0.1 backup. Restore over 2.1, apply metadata fix scripts, and see, for example, "clientes" fields descriptions.
It?s a ISO8859_1 database.