Page 1 of 1

? instead of national characters

Posted: Wed 19 Apr 2006 12:33
by creams
Hello,

I've got all my database texts encoded using the Polish ISO-8859-2 characters set (it's latin2). When I retrieve data to a local dataset, every special Polish character is replaced with the "?" char. How can I make the fields contain strings in a "RAW" format, the same as it is in the database? I've got procedures to convert the ISO-8859-2 texts to the current Windows locale, but I'm not able to do this because the texts come with the "?" chars instead of the correct encoding. Please help.

Delphi 6 Pro UP2
mySQL server version 4.x

Posted: Thu 20 Apr 2006 09:41
by Antaeus
Try using SET NAMES to set corresponding character set on client side. Plese read MySQL Reference Manual for detailed information.