Posted by news@celticbear.com on 10/22/27 11:34

We just upgraded our phpMyAdmin GUI to the latest stable version, and
now the SQL queries are doing odd additions.
First, without changing the database it's connecting to at all, there's

a new column "collation" for all the tables, and the value in all of
them is: "latin1_swedish_ci".
I'm doubting that's what it should be.


And any SQL querey formulates like:


SELECT *
FROM `accounts`
WHERE `company` LIKE CONVERT( _utf8 'cyber'
USING latin1 )
COLLATE latin1_swedish_ci
LIMIT 0 , 30


with new CONVERT and COLLATE, instead of the usual queries like:


SELECT *
FROM `accounts`
WHERE `company` LIKE '%cyber%'
LIMIT 0 , 30


I can't find in the documentation why it's doing this, and looking
through conf.inc.php, can't find any setting that may apply.


Any clue what I should look at?
Is it simply displaying some quality about the mySQL database that had
heretofore not been exposed? If Collation is an attribute that is there

and must now be taken into account, it looks like I can change it in
"Operations," what's the proper, standard English setting?
"ascii_gen_cli"?


Thanks for any feedback!
-Liam

• Next in forum: Re: php deployment
• Prev in forum: Send mail to multiple address
• Thread view: new phpMyAdmin collate and convert oddness

[Reply to this message]