The output of the cmds is this:
mysql> show variables like "collation%"; +----------------------+-------------------+ | Variable_name | Value | +----------------------+-------------------+ | collation_connection | latin1_swedish_ci | | collation_database | latin1_general_cs | | collation_server | latin1_swedish_ci | +----------------------+-------------------+ 3 rows in set (0.00 sec) mysql> show create table admin; +-------+------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- --------------------------------------------+ | Table | Create Table | +-------+------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- --------------------------------------------+ | admin | CREATE TABLE `admin` ( `u_id` int(10) unsigned NOT NULL auto_increment, `member_id` varchar(13) collate latin1_general_ci NOT NULL default '', `password` text collate latin1_general_ci NOT NULL, PRIMARY KEY (`u_id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='admin identification' | +-------+------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- --------------------------------------------+ 1 row in set (0.00 sec) mysql> Mit freundlichen Grüßen Jürgen Ladstätter ( [EMAIL PROTECTED] ) _______________________________________________ P.I.C.S. EDV GmbH. A-5020 Salzburg, Landsturmstraße 18 Tel.: +43 (662) 455467 Fax.: +43 (662) 455468 Web: http://www.pics.co.at E-Mail: [EMAIL PROTECTED] Ihr Partner für Internet, Computer und Software _______________________________________________ -----Ursprüngliche Nachricht----- Von: Dan Buettner [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 22. August 2006 16:33 An: Jürgen Ladstätter Cc: mysql@lists.mysql.com Betreff: Re: mysql program wont work after mysqlserver update Jürgen, I wonder if you have properly set collations in just some areas? show variables like "collation%"; show create table <tablename>; (for each table involved) I would think you'd want this all to match ... though I am not an expert in this area. Dan SHOW COLLATION On 8/22/06, Jürgen Ladstätter <[EMAIL PROTECTED]> wrote: > Hi Dan, > > first of all thanks for your reply, but i already changed the password to > the "old_style" password, otherwise i wouldnt be able to connect and > authenticate at all! > But there must be anything else :-/ > I don't think that I need to write a new MySQL component to talk with my > server, or let the 4.0 version run foever :-/ > I know that there is a solution - but where :) > > Mit freundlichen Grüßen > > Jürgen Ladstätter ( [EMAIL PROTECTED] ) > > _______________________________________________ > > P.I.C.S. EDV GmbH. > A-5020 Salzburg, Landsturmstraße 18 > Tel.: +43 (662) 455467 > Fax.: +43 (662) 455468 > > Web: http://www.pics.co.at > E-Mail: [EMAIL PROTECTED] > Ihr Partner für Internet, Computer und Software > _______________________________________________ > > -----Ursprüngliche Nachricht----- > Von: Dan Buettner [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 22. August 2006 14:52 > An: Jürgen Ladstätter > Cc: mysql@lists.mysql.com > Betreff: Re: mysql program wont work after mysqlserver update > > Jürgen, not sure if this would be it, but password handling changed > somewhat with MySQL 4.1. From your error msg it seems doubtful, but > thought I'd mention it. > > http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html > > Dan > > > On 8/22/06, Jürgen Ladstätter <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > > > > > i developed a c+ programm which uses dbx to get access to my mysqlserver. > > Now I needed to change provider and so I have my own server here :-) > > > > the old server was a 4.0.24 and now I have a 4.1.21. > > > > the problem is: when I connect and want to access any data, I get the > error > > message, that the "translation is illegal" I really don't know what this > > means! Collation is set to latin1_general_ci, as on the old server :-( > > > > > > > > do you have any ideas? > > > > > > > > Mit freundlichen Grüßen > > > > Jürgen Ladstätter ( [EMAIL PROTECTED] ) > > > > _______________________________________________ > > > > P.I.C.S. EDV GmbH. > > A-5020 Salzburg, Landsturmstraße 18 > > Tel.: +43 (662) 455467 > > Fax.: +43 (662) 455468 > > > > Web: <http://www.pics.co.at> http://www.pics.co.at > > E-Mail: [EMAIL PROTECTED] > > Ihr Partner für Internet, Computer und Software > > _______________________________________________ > > > > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]