string malformed

abed · Post by **abed** » Wed 28 Dec 2011 18:25

Help,
I'm using delphi 2007 with unidac ver. 4, firebird 2.5
my connection Useunicode=True, charset=ISO8859_1
when i post this string TOLEDO - ESPAÑA to blob field i get the error 'STRING MALFORMED' with external tools like flamerobin it goes ok,
any help to workaround?

AndreyZ · Post by **AndreyZ** » Thu 29 Dec 2011 14:08

Hello,

Thank you for the information. We have reproduced the problem and investigation of the problem is in progress. As soon as we have any results we will let you know.

AndreyZ · Post by **AndreyZ** » Thu 26 Jan 2012 09:45

We have investigated this problem. The problem occurs because you set the UseUnicode property to True. In this case, UniDAC doesn't use the Charset property and connects to a database using the UNICODE_FSS (or UTF8, if you set it) charset. Firebird cannot convert characters between the UNICODE_FSS and ISO8859_1 charsets. To solve the problem, you should set the UseUnicode property to False.