myodbc and character sets

Hello,

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!


---------------
<charset name="latin1">
  <family>Western</family>
  <description>ISO 8859-1 West European</description>
  <alias>csisolatin1</alias>
  <alias>iso-8859-1</alias>
  <alias>iso-ir-100</alias>
  <alias>iso_8859-1</alias>
... 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@xxxxxxxxxxx