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