ok folks, I was digging into my own problem and that's what I found:
host 'hegel' running 3.23.39 is using character_set latin1 host 'fidel' running 4.0.1 is using character_set latin1_de latin1_de is character set '#31' mentioned in the error message below. Character set latin_de was introduced with release 4.0.0. From the very fine manual: Changes in release 4.0.0 * New character set `latin_de' which provides correct German sorting. Does this mean that clients before ver 4.0.0 can't access new servers with correct German sorting??? Thomas On Thu, 6 Jun 2002, Thomas Spahni wrote: > Dear listmembers, > > I've got 2 hosts running Linux: hostnames are 'hegel' and 'fidel' > > me@hegel:~>mysqladmin version > mysqladmin Ver 8.21 Distrib 3.23.39, for pc-linux-gnu on i586 > > me@fidel:~>mysqladmin version > mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686 > > When logged in to 'hegel' I can't mysqlshow the databases on 'fidel'. It > works, but gives an error. > > me@fidel:~> mysqlshow -u me -h fidel > +-----------+ > | Databases | > +-----------+ > | bge | > | mysql | > | something | > | test | > +-----------+ > > me@hegel:~> mysqlshow -u me -h fidel > mysqlshow: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) > mysqlshow: Character set '#31' is not a compiled character set and is not > specified in the '/usr/share/mysql/charsets/Index' file > +-----------+ > | Databases | > +-----------+ > | bge | > | mysql | > | something | > | test | > +-----------+ > > However, it runs fine the other way round (4.0.1 client, 3.23.39 server): > > me@fidel:~> mysqlshow -u me -h hegel > +--------------+ > | Databases | > +--------------+ > | casino | > | mitteilungen | > | mysql | > | ssl | > | test | > +--------------+ > > What happens? Any insights what to look for? > Thomas Spahni --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
