Skip navigation links

MySQL Forums :: General :: Strange behavior between mysql versions with binary


Advanced Search

Strange behavior between mysql versions with binary
Posted by: Laurent MINOST ()
Date: April 27, 2012 06:58AM

Hi,

We are using two mysql servers in our dev environnment hosted on Linux Debian : dedwen(mysql 5.0.32-Debian_7etch6-log) and djen(mysql 5.1.49-3).

I recently needed to move a database from dedwen to djen for performance reasons, so I dumped it with mysqldump then import it on djen.

I'm now facing a 'strange' problem :

1 - Using mysql command line client from dedwen or djen and issuing following query outputs following results :

mysql> SELECT * FROM redonline_foodsafety.theme WHERE name like binary 'Précaution';
Empty set (0.03 sec)

2 - Using TOAD for MySQL Free Version and issuing the same query :
-> On dedwen it outputs properly the only row that is matching.
-> On djen it outputs nothing.

3 - Using PHPMyAdmin as client and issuing the same query outputs successfully the only row that is matching on the two servers.

Based on the fact that the outputs seems to change between clients, I was thinking of a client related problem due to charset/collation issues BUT it seems also related with the binary keyword because if I remove the binary keyword from the query then this one outputs correctly the results in every client ?!

What is the problem here please ? Do you have any advise/idea/recommandation about this please ?

Thanks.
Regards,

Laurent

Options: ReplyQuote


Subject Written By Posted
Strange behavior between mysql versions with binary Laurent MINOST 04/27/2012 06:58AM
Re: Strange behavior between mysql versions with binary Rick James 04/28/2012 01:46PM
Re: Strange behavior between mysql versions with binary Laurent MINOST 04/30/2012 01:35AM
Re: Strange behavior between mysql versions with binary Rick James 04/30/2012 09:36PM
Re: Strange behavior between mysql versions with binary Laurent MINOST 05/02/2012 08:03AM
Re: Strange behavior between mysql versions with binary Rick James 05/03/2012 08:32AM
Re: Strange behavior between mysql versions with binary Laurent MINOST 05/04/2012 07:18AM
Re: Strange behavior between mysql versions with binary Rick James 05/05/2012 09:11AM
Re: Strange behavior between mysql versions with binary Laurent MINOST 05/09/2012 03:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.