Re: converting curly apostrophes to standard apostrophes

--- Michael Fuhr <mike(at)fuhr(dot)org> 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