converting with AnsiToUTF8 doesn't give the right string
lazarus / 16-Databases

----------------------------------------------------------------------
mangakissa · 2020-02-26 15:18

I'm changing my database from MySQL to Firebird 3.
In a table some names are put like this:
QuoteA.B. FRILLESÅS HANDELSTRÄDG.The whole mysql database uses code
latin1 for these characters.
Now I copy from a MySQL table to a FB table. I have to use
AnsitoUTF8() to translate the extended characters otherwise Lazarus
comes with an error : "malformed string". This is an error returned
from Firebird. But it convert it to this:
QuoteA.B. FRILLES�S HANDELSTR�DG.On the Firebird FAQ the solution to
write it right is to put 'set names win1252;' at first in the isql.

But how when using Lazarus? AnsitoUTF8() converts the string, but not
with the right characters.

----------------------------------------------------------------------
Bart · 2020-02-26 16:31

Maybe WinCPToUTF8 does what you need?
(Unit LazUtf8)

Bart

----------------------------------------------------------------------
mangakissa · 2020-02-27 08:04

thanks, Bart.

The right conversion.