| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
| Cc: | db(at)zigo(dot)dhs(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Lexing with different charsets |
| Date: | 2004-04-14 02:30:22 |
| Message-ID: | 20040413192942.W62811@megazone.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 14 Apr 2004, Tatsuo Ishii wrote:
> > I've spent some more time reading specs today. Together with Peter E's
> > explanataion (Thanks!) I think I've got a farily good understanding of the
> > parts talking about locales now.
> >
> > My next question is about lexing. The spec says that one can use strings
> > of different charsets in the queries, like:
> >
> > ... WHERE field1 = _latin1'FooBar' and field2 = _utf8'Åäö'
>
> In my understanding this was removed as of SQL:1999. I'm not sure
> about SQL:2003 though.
AFAICS, it still basically has:
<character string literal> ::=
[ <introducer><character set specification> ]
<quote> [ <character representation>... ] <quote>
[ { <separator> <quote> [ <character representation>... ] <quote> }... ]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2004-04-14 03:34:24 | Re: PostgreSQL configuration |
| Previous Message | Tatsuo Ishii | 2004-04-14 01:18:55 | Re: Lexing with different charsets |