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]