myodbc and character sets
am 25.11.2005 10:59:50 von Evangelos SouglakosHello,
I have installed a freebsd 6.0 box with
mysql-server-4.1.13
myodbc-iodbc-mysql41-3.51.11
libiodbc-3.52.2
I 'm trying to setup an openldap server with mysql backend.
iodbc and myodbc seem to work perfectly (connect to mysql server etc etc)
The problem is that myodbc claims it can't find the default character set
"latin1"
------------------------------------------------------------ -
==>backsql_open_db_conn()
Character set 'latin1' is not a compiled character set and is not
specified in the '/usr/local/share/mysql/charsets/Index.xml' file
backsql_open_db_conn: SQLConnect() to database "ldap" as user "root" failed:
Return code: -1
Native error code: 2019
SQL engine state: S1T00
Message: [MySQL][ODBC 3.51 Driver]Can't initialize character
set latin1 (path: /usr/local/share/mysql/charsets/)
------------------------------------------------------------ -
This file "/usr/local/share/mysql/charsets/Index.xml" exists and it has
the latin1 declaration!
---------------
.... etc etc etc..
---------------
MySQL has been installed as a freebsd 6.0 package
When i type:
mysql> SHOW CHARACTER SET
-> ;
+----------+-----------------------------+------------------ ---+--------+
| Charset | Description | Default collation | Maxlen |
+----------+-----------------------------+------------------ ---+--------+
| dec8 | DEC West European | dec8_swedish_ci | 1 |
| cp850 | DOS West European | cp850_general_ci | 1 |
| hp8 | HP West European | hp8_english_ci | 1 |
| koi8r | KOI8-R Relcom Russian | koi8r_general_ci | 1 |
| latin1 | ISO 8859-1 West European | latin1_swedish_ci | 1 |
| latin2 | ISO 8859-2 Central European | latin2_general_ci | 1 |
| swe7 | 7bit Swedish | swe7_swedish_ci | 1 |
| ascii | US ASCII | ascii_general_ci | 1 |
| hebrew | ISO 8859-8 Hebrew | hebrew_general_ci | 1 |
| koi8u | KOI8-U Ukrainian | koi8u_general_ci | 1 |
| greek | ISO 8859-7 Greek | greek_general_ci | 1 |
| cp1250 | Windows Central European | cp1250_general_ci | 1 |
| latin5 | ISO 8859-9 Turkish | latin5_turkish_ci | 1 |
| armscii8 | ARMSCII-8 Armenian | armscii8_general_ci | 1 |
| utf8 | UTF-8 Unicode | utf8_general_ci | 3 |
| cp866 | DOS Russian | cp866_general_ci | 1 |
| keybcs2 | DOS Kamenicky Czech-Slovak | keybcs2_general_ci | 1 |
| macce | Mac Central European | macce_general_ci | 1 |
| macroman | Mac West European | macroman_general_ci | 1 |
| cp852 | DOS Central European | cp852_general_ci | 1 |
| latin7 | ISO 8859-13 Baltic | latin7_general_ci | 1 |
| cp1251 | Windows Cyrillic | cp1251_general_ci | 1 |
| cp1256 | Windows Arabic | cp1256_general_ci | 1 |
| cp1257 | Windows Baltic | cp1257_general_ci | 1 |
| binary | Binary pseudo charset | binary | 1 |
| geostd8 | GEOSTD8 Georgian | geostd8_general_ci | 1 |
+----------+-----------------------------+------------------ ---+--------+
All character sets are ok!
I would be very grateful if anyone can help me.
Thank you,
--
Evangelos Souglakos
Network Operations Center
Department of Informatics
University of Athens
Panepistimioupolis, Illisia
157 84, Athens
Greece
Tel: +30 210 727-5612
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org