Re: Lexing with different charsets

Dennis Bjorklund <db(at)zigo(dot)dhs(dot)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