dz_boy
11-03-2009, 06:44 PM
I have a weird character set issue. Sometimes when I upload records into my database through Safari, the apostrophe character (it's copied out of MS Word) enters the database and is displayed as an Õ, and O with a tilde. I would like to replace this Õ character with apostrophes, but when I try to select each record with with
WHERE 'headline' LIKE '%Õ%'
it selects each row with a lowercase "o" character, so it doesn't help me at all. Is there a way to ensure that this where clause will only return headlines with the actual Õ instead of all o's?
Thanks!
WHERE 'headline' LIKE '%Õ%'
it selects each row with a lowercase "o" character, so it doesn't help me at all. Is there a way to ensure that this where clause will only return headlines with the actual Õ instead of all o's?
Thanks!