Thanks for your kindly reply, I have filed an enhancement bug here: http://bugs.monetdb.org/show_bug.cgi?id=3010 Thanks, Tony -----邮件原件----- 发件人: Sjoerd Mullender [mailto:sjoerd@acm.org] 发送时间: 2012年2月15日 21:45 收件人: Dongli 抄送: monetdb-users@lists.sourceforge.net 主题: Re: Does Monetdb supports UTF-8 characters when I use 'as' clause? 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