MySQL Forums :: Newbie :: how to replace hex in varchar field


Advanced Search

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

Hi,

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.

Wim



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

Options: ReplyQuote


Subject Written By Posted
how to replace hex in varchar field Wim Merjenburgh 05/18/2011 06:22AM
Re: how to replace hex in varchar field laptop alias 05/18/2011 06:29AM
Re: how to replace hex in varchar field Wim Merjenburgh 05/18/2011 07:04AM
Re: how to replace hex in varchar field Rick James 05/21/2011 05:53PM


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.