Zeos 6.5.1 and MySQL 5.1 - charset confusion

zippo · Post by **zippo** » 10.12.2005, 17:06

Hello!

I need some help about MySQL 5.1 and character set..

I use Slovenian charset (cp1250) in my apps, but the problem is i get special characters as "?" (a question mark) regardless to the server charset setting...

Any ideas on how to obtain "normal" strings?

zippo · Post by **zippo** » 10.12.2005, 17:12

problem almost resolved!

Just needed to retype the values in the application.

But there's still a strange thing - If I enter the field values in another program (example MySQL Query browser) the special chars are still "?"...

designshouse · Post by **designshouse** » 15.12.2005, 11:47

i have the same problem. Any ideas ?

zippo · Post by **zippo** » 18.12.2005, 08:43

Inset the values from your application.. Fast and dirty, but when there's no time...

designshouse · Post by **designshouse** » 19.12.2005, 08:01

Zconnection component has property with name Properties. Put there this "Codepage=cp1250"

Codepages

Codepages will be determined by setting parameter "lc_ctype" or "Codepage" in TZConnection. This parameter must be added to the property Properties. E. g.:

delphi:
ZConection.Properties.Add ('lc_ctype=ISO8859_1');

or

ZConnection.Properties.Add ('Codepage=ISO8859_1');

Sorry for my english :-)

dhongu · Post by **dhongu** » 19.12.2005, 08:44

Look at [ 1176107 ] Patch for MySQL 4.1 Character Set
http://sourceforge.net/tracker/index.ph ... tid=415826