mySql collation - why is this simple search not working?

[susanBuck]

Here's my issue -

Doing a Search in phpAdmin turns up no results even though I know it should be finding something.

The SQL search query result is showing this weird convert collate thing i've never seen before :

SELECT * 
FROM  `orders` 
WHERE  `ref` LIKE CONVERT( _utf8 '4PF37651K22263031'
USING latin1 ) 
COLLATE latin1_swedish_ci
LIMIT 0 , 30

 

Here's a screencast of me trying to do the search - where you can see exactly what i'm talking about http://screencast.com/t/0yGHAufCl9

 

 

Note that we've recently updated our servers to mySql 4...and based on research i'm suspecting this is related... just don't know how to fix it!

 

Additional note , not sure if its relevant but - the data for the "ref" field which i'm trying to search, is data POSTed back from a paypal IPN transaction.

[luca200]

It sounds a little weird to me... but just try changing the connection collation on phpmyadmin homepage to latin1_swedish_ci