MySQL Forums
Forum List  »  Newbie

how to replace hex in varchar field
Posted by: Wim Merjenburgh
Date: May 18, 2011 06:22AM


It's quite a while I did some minor development for MySQL. So please excuse if it turns out to be a quite straightforward question.

I have a table containing two columns: id and descriptioon. The id-column has datatype 'int', the txt-column has datatype 'varchar(11200)'. This 2nd columns appears to contain an in the workbench invisible 'single right quotation mark'. This is char(146). So:
select hex(char(146)) returns '92'.

Now I have two questions:
1- how can I test if the txt-column contains this character
2- how can I replace this character

I hope you can help me.


Edited 1 time(s). Last edit at 05/18/2011 07:01AM by Wim Merjenburgh.

Options: ReplyQuote

Written By
how to replace hex in varchar field
May 18, 2011 06:22AM

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.