How to change dotConnect default client encoding
Posted: Thu 26 Nov 2009 17:21
Hi,
I have dotConnect 5.40.44.
I have a MySql 5.0.51a (Debian linux) server with all encoding setting variables set to utf8.
I connect against a database having some foreign characters in field names on certain tables.
It seems that by default, dotConnect uses a latin1 encoding as a client because the field names appear with the usual "strange" Äx kind of characters.
In fact, if I use "character set=utf8" in the connexion string, it solves the problem.
However I have 2 issues on that:
- Your doc states that I can use the "character set" option in the connexion string but that I'd better "synchronize client and server encoding". My question is: How do I do that? I connot find a client configuration file that allows me to tell dotConnect to use utf8 by default.
- I use a third party OR/M software, namely LLBGen Pro, that uses dotConnect driver but doesn't allow me to customize the conection string. So I'm stuck with my bad field names. What can I do?
here is an excerpt from my MySql server conf:
character set client utf8
character set connection utf8
character set database utf8
character set filesystem binary
character set results utf8
character set server utf8
character set system utf8
character sets dir /usr/share/mysql/charsets/
collation connection utf8_unicode_ci
(Valeur globale) utf8_general_ci
collation database utf8_general_ci
collation server utf8_general_ci
Regards.
I have dotConnect 5.40.44.
I have a MySql 5.0.51a (Debian linux) server with all encoding setting variables set to utf8.
I connect against a database having some foreign characters in field names on certain tables.
It seems that by default, dotConnect uses a latin1 encoding as a client because the field names appear with the usual "strange" Äx kind of characters.
In fact, if I use "character set=utf8" in the connexion string, it solves the problem.
However I have 2 issues on that:
- Your doc states that I can use the "character set" option in the connexion string but that I'd better "synchronize client and server encoding". My question is: How do I do that? I connot find a client configuration file that allows me to tell dotConnect to use utf8 by default.
- I use a third party OR/M software, namely LLBGen Pro, that uses dotConnect driver but doesn't allow me to customize the conection string. So I'm stuck with my bad field names. What can I do?
here is an excerpt from my MySql server conf:
character set client utf8
character set connection utf8
character set database utf8
character set filesystem binary
character set results utf8
character set server utf8
character set system utf8
character sets dir /usr/share/mysql/charsets/
collation connection utf8_unicode_ci
(Valeur globale) utf8_general_ci
collation database utf8_general_ci
collation server utf8_general_ci
Regards.