Re: Lexing with different charsets

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> }... ]