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