CRBatchmove

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
michaelJ
Posts: 30
Joined: Thu 13 Jan 2011 16:11

CRBatchmove

Post by michaelJ » Fri 03 Aug 2012 15:51

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?

ZEuS
Devart Team
Posts: 240
Joined: Thu 05 Apr 2012 07:32

Re: CRBatchmove

Post by ZEuS » Mon 06 Aug 2012 11:23

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.

Post Reply