Ricky Mathew Ricky Mathew - 1 year ago 90
SQL Question

sql '=' operetor returns unexpected result

here is my query

FROM `tx_branddata_info`
WHERE `brand_title` = 'BOEHLER'
LIMIT 0 , 30

it returns

enter image description here

but the expected result is the first one.any one have any solution other than changing the collation.

Answer Source

Seems brand_title 's following latin1_german2_ci rules (http://dev.mysql.com/doc/refman/5.7/en/charset-we-sets.html):

Ä = AE
Ö = OE
Ü = UE
ß = ss

Check field character set and change, if you can obviously, to, imho, utf8mb4.

Hope this helps.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download