Re: Lexing with different charsets

Dennis Bjorklund <db@zigo.dhs.org> writes:
> 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'���'
> I can see that the lexer either needs to be taught about all the
> different charsets or this is not going to work very well.

Yeah.  I'm not sure that we're ever going to support that part of the
spec; doing so would break too many useful things without adding very
much useful functionality.

We could possibly do it if we restrict to ASCII-superset character sets
(not UTF-16 for instance), so that the string quoting boundaries can be
found without hardwired knowledge about every character set.
        regards, tom lane