RE: Killing my curly quotes

["J.R. Bullington" <suppressed>]

Windows or Linux??

The REPLACE() function would do it if using the Character Mapping in
Windows.

UPDATE tbl_Name SET col1 = REPLACE(col1,'"','"')
UPDATE tbl_Name SET col1 = REPLACE(col1,'"','"')

They are ALT+0147 and ALT+0148 in Windows Character Map (charmap.exe)


J.R.

-----Original Message-----
From: Brian Dunning [mailto:suppressed 
Sent: Monday, December 05, 2005 2:13 PM
To: suppressed
Subject: Killing my curly quotes

OK, I'm bad - I have curly quotes in my db that I failed to eliminate prior
to the insert. Now that they're in there, is there a way to replace them
with straight quotes? Everything I try fails to find them.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed