how to replace hex in varchar field

[Wim Merjenburgh]

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.