[solved]Problem with special characters

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
dreamline
Forum Contributor
Posts: 158
Joined: Fri May 28, 2004 2:37 am

[solved]Problem with special characters

Post by dreamline »

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.. :)
Post Reply