Configure innoDB case insensitive with UTF8
Configure innoDB case insensitive with UTF8
Is there some way I can select from an innoDB table, with char-set UTF8, in a case insensitive mode?
Table:
-----------------------
country | city
-----------------------
SE | Stockholm
US | New york
...
This query works:
SELECT country FROM cities WHERE cityName = 'Stockholm'
This query does NOT work:
SELECT country FROM cities WHERE cityName = 'stockholm'
What is the problem? InnoDB, UTF8 or me? :)
Any thoughts?
// Michelle
Subject
Written By
Posted
Configure innoDB case insensitive with UTF8
January 08, 2005 09:38AM
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.