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> }... ]
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
