converting with AnsiToUTF8 doesn't give the right string

[mangakissa]

I'm changing my database from MySQL to Firebird 3.
In a table some names are put like this:

A.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:

A.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]

Maybe WinCPToUTF8 does what you need?
(Unit LazUtf8)

Bart

[mangakissa]

thanks, Bart.

The right conversion.