--- Michael Fuhr <mike@xxxxxxxx> wrote: > On Mon, Aug 15, 2005 at 12:14:16PM -0700, CSN wrote: > > Is there a way to replace all curly apostrophes > with > > standard apostrophes (presumably with > replace(x,y,z))? > > My database is SQL_ASCII and I can't find a > character > > code for curly apostrophes in ASCII here: > > http://www.lookuptables.com, but nevertheless > there > > appear to be curly apostrophes in the database. > > The "Extended ASCII Codes" section of that page > might not match > what your system uses (it doesn't match mine). Have > you tried using > the ascii() function on the offending data? I logged back in after changing putty's charset to UTF-8 and am now able to paste an ? (curly apostrophe) into psql, however that character still appears as a grey box in psql's select output. I've tried various queries to find which rows and fields contain it, without success (I know it's in some of them): db=>select ascii('?'); ascii ------- 226 db=>select id from news where body ilike '%?%'; (0 rows) db=>select id from news where body ilike '%' || chr(226) || '%'; db'> db'>^C db=> CSN __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
