Axel Richter: seltsamer Fehler beim connect DBI::mysql

Beitrag lesen

Hallo,

Entweder ist character-sets-dir= in my.ini falsch gesetzt, oder Perl hat einen ähnlichen Bug wie PHP hier: http://bugs.php.net/bug.php?id=22083&edit=3.

Oder es existiert gar kein Charsets-Index für MySQL, wie hier http://dev.mysql.com/doc/mysql/de/Problems_with_character_sets.html angemerkt.
---------------------------------------------------------------------
Posted by Götz Lohmann on March 2 2004 7:58am [Delete] [Edit]

If you got an error like:

File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#5' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file

check if '/usr/share/mysql/charsets/Index' exists, cause the RPM package of "mysql 4.1" seem not to create one.

the file looks like:
---- begin of file Index ----

sql/share/charsets/Index

This file lists all of the available character sets.

Please keep this file sorted by character set number.

big5 1
czech 2
dec8 3
dos 4
german1 5
...
latin1_de 31
---- end of file Index ----

take a look at http://www.mysql.com/doc/en/Charset-map.html for the full table.

You also might look in a search engine like google to find a tarball to copy the file out in your directory. Also you might need the 'latin1.conf', 'latin2.conf', 'usa7.conf', .. in your charset directory. There is a lot xml files in the charset directory, but they don't seem to be used yet?

Hope this might help someone.
---------------------------------------------------------------------

viele Grüße

Axel