[solved]Problem with special characters
Posted: Thu May 25, 2006 2:46 pm
Hi all,
I've got a bit of a problem... In my database I have characters like ë, é, â and if I use a query like 'select * from table where title like '%bee%' then a result with the special characters like 'bëe' will also pop up in the results...
Is there an easy way to do the query so that these special characters are not popping up in the results?
Thanks for any help..
I've got a bit of a problem... In my database I have characters like ë, é, â and if I use a query like 'select * from table where title like '%bee%' then a result with the special characters like 'bëe' will also pop up in the results...
Is there an easy way to do the query so that these special characters are not popping up in the results?
Thanks for any help..