MySQL Forums
Forum List  »  Install & Repo

Configure innoDB case insensitive with UTF8
Posted by: michelledebeer
Date: January 08, 2005 09:38AM

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

Options: ReplyQuote


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.