You're correct, MonetDB does not currently support non-ASCII names in identifiers. The syntax using double quotes (select source as "我" from session;) would be the correct one if we did support it, but we don't. Please file a bug report for this (set Severity to Enhancement). On 2012-02-15 10:10, Dongli wrote:
Hi folks,
Please take a look at following issue that I got today:
The following queries I executed aim to test if Monetdb supports GBK characters(Chinese), since I have to use Chinese characters in my system to display the reports.
I’m not sure if I missed some setting such as ‘set characters=’utf-8’? The following alias after the ‘as’ is a Chinese character ‘I’.
sql>select source as '我' from session;
42000!syntax error, unexpected STRING in: "select source as '我'"
sql>select source as 我from session;
unexpected character (U+6211)
sql>select source as "我" from session;
Invalid identifier '我'
Thanks in advance,
Tony
-- Sjoerd Mullender