--- Michael Fuhr <[EMAIL PROTECTED]> 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
