MySQL Forums
Forum List  »  Newbie

Re: Searching database for strings with Swedish characters
Posted by: Barry Galbraith
Date: December 14, 2013 04:43AM

Something along the lines of this will replace every a1cc88 with c3a4.

UPDATE your_table SET name_field = REPLACE(NAME,0xa1cc88, 0xc3a4);

Good luck,

Options: ReplyQuote

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.