MySQL Forums
Forum List  »  PHP

utf8 accentless query
Posted by: MBJr.
Date: February 05, 2006 07:39AM

Hi there,

I'm just wondering if there's any way to query an utf8 enabled database with a latin1 keyword.

Let's say I have a table with:

+---+--------
| Id | Name
+---+--------
| 1 | csülök
+---+--------

So I can get a result with:
select * from myTable where Name like 'csülök';

But what if my keyword is 'csulok' instead of 'csülök'?
Can I tell MySQL somehow to use accentless "like"?

Thanks in advance,
MB::Jr.

Options: ReplyQuote


Subject
Written By
Posted
utf8 accentless query
February 05, 2006 07:39AM


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.