Hello,
when I transfer a table from Firebird 1.5 (Charset win1252) with 'german umlaute' to a Firebird V2.5 Database (Charset UTF8) with CRBatchmove then I've got the following Error:
Dynamic SQL Error
SQL error code = -303
Malformed string
With DBMonitor I can see that the Parameter Contains öäüß 'german umlaute'
What can I do to avoid the Problem?
CRBatchmove
Re: CRBatchmove
The error may occur when the application tries to insert data from a field that has the WIN1252 character set into the field with the UTF8 character set, but, in fact, data is not converted from WIN1252 to UTF8. To avoid the error you can try one of the following combinations in the Options property of the destination TIBCConnection component:
- the UseUnicode option is set to True;
- the UseUnicode option is set to False, and Charset option is set to WIN1252 or NONE.
- the UseUnicode option is set to True;
- the UseUnicode option is set to False, and Charset option is set to WIN1252 or NONE.