Re: [GENERAL] converting curly apostrophes to standard apostrophes

2005-08-15 Thread CSN
--- Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Mon, Aug 15, 2005 at 01:48:00PM -0700, CSN wrote: > > 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

Re: [GENERAL] converting curly apostrophes to standard apostrophes

2005-08-15 Thread Michael Fuhr
On Mon, Aug 15, 2005 at 01:48:00PM -0700, CSN wrote: > 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=> What's going on with the last que

Re: [GENERAL] converting curly apostrophes to standard apostrophes

2005-08-15 Thread CSN
--- 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

Re: [GENERAL] converting curly apostrophes to standard apostrophes

2005-08-15 Thread Michael Fuhr
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

[GENERAL] converting curly apostrophes to standard apostrophes

2005-08-15 Thread CSN
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 datab