? instead of national characters

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
creams
Posts: 3
Joined: Sat 01 Apr 2006 12:51

? instead of national characters

Post by creams » Wed 19 Apr 2006 12:33

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

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Thu 20 Apr 2006 09:41

Try using SET NAMES to set corresponding character set on client side. Plese read MySQL Reference Manual for detailed information.

Post Reply