myodbc and character sets

myodbc and character sets

am 25.11.2005 10:59:50 von Evangelos Souglakos

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!


---------------

Western
ISO 8859-1 West European
csisolatin1
iso-8859-1
iso-ir-100
iso_8859-1
.... 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

Re: myodbc and character sets

am 25.11.2005 13:37:38 von Sergey Prikhodko

Hello, Evangelos,

Friday, November 25, 2005, 11:59:50 AM, you wrote:

> Hello,

> 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/)


It's still-not-fixed-from-10-Nov-2004-bug :)

Please, see http://bugs.mysql.com/bug.php?id=6536 for workaround.
Send me feedback, if it will help you, I'll include patch in next
update of FreeBSD port.

P.S. use google
http://www.google.com.ua/search?hl=uk&q=%22Character+set+%27 latin1%27+is+not+a+compiled+character+set+and+is+not%22&btnG =%D0%9F%D0%BE%D1%88%D1%83%D0%BA&meta=


--
Sergey Prikhodko mailto:sergey@network-asp.biz
Network-ASP Ltd. http://www.network-asp.biz/
ICQ: 83537536


--
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