Page 1 of 1
Zeos 6.5.1 and MySQL 5.1 - charset confusion
Posted: 10.12.2005, 17:06
by zippo
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?
Posted: 10.12.2005, 17:12
by zippo
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 "?"...
Posted: 15.12.2005, 11:47
by designshouse
i have the same problem. Any ideas ?
Posted: 18.12.2005, 08:43
by zippo
Inset the values from your application.. Fast and dirty, but when there's no time...
Posted: 19.12.2005, 08:01
by designshouse
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 :-)
Posted: 19.12.2005, 08:44
by dhongu
Look at [ 1176107 ] Patch for MySQL 4.1 Character Set
http://sourceforge.net/tracker/index.ph ... tid=415826