Do you actually need Chinese characters in identifiers or just in the data stored in the database? For example: sql>select '我'; +--------------+ | single_value | +==============+ | 我 | +--------------+ 1 tuple (0.517ms) and more importantly: sql>create table hantext (s varchar(20)); sql>insert into hantext (s) values("hello"); sql>insert into hantext (s) values('我'); sql>insert into hantext (s) values('没问题'); sql>select * from hantext; +-------+ | s | +=======+ | hello | | 我 | | 没问题 | +-------+ 3 tuples (0.591ms) This test was run on OSX 10.7.3 with MonetDB v11.5.9 (Aug2011-SP3). HTH, -david On Wed, Feb 15, 2012 at 8:34 AM, Dongli <bai.dongli@gmail.com> wrote:
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
------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users