MySQL ODBC Connector - Best case-insensitive search for Character Set utf8 COLLATE utf8

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Best case-insensitive search for Character Set utf8 COLLATE utf8_bin Columns.

Robert DiFalco

2005-12-27, 8:24 pm

What is the best (most optimal) way to perform a case-insensitive search
for a VARCHAR column with COLLATE utf8_bin?

I'm assuming the answer is not:

SELECT *=20
FROM MyTable=20
WHERE UPPER(MyColumn) LIKE Upper('%pattern%');

Tia!

R.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links