|
|
Posted by Juliette on 10/19/47 11:34
news@celticbear.com wrote:
> 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
>
You are using a MySQL version >= 4.1 which supports charsets and
collation. Have a look at the mysql documentation.
For English charset you could use latin1_general_ci
Grz, Jrf
Navigation:
[Reply to this message]
|