--- 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
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
--- 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
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
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