Date: 2012-02-15 15:30:42 +0100
From: baidongli
To: SQL devs <>
Version: -- development
CC: @yzchang

Last updated: 2019-01-21 16:34:19 +0100

Comment 16888

Date: 2012-02-15 15:30:42 +0100
From: baidongli

User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.1) Gecko/20100101 Firefox/10.0.1
Build Identifier: MonetDB 5 server v11.7.5 "Dec2011" (64-bit, 64-bit oids)

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

Reproducible: Always

Comment 17694

Date: 2012-08-24 14:56:06 +0200
From: @sjoerdmullender

Jul2012-SP1 has been released.

Comment 18131

Date: 2012-11-27 15:47:49 +0100
From: @yzchang

No test needed for feature request

Comment 26822

Date: 2019-01-21 16:34:19 +0100
From: @sjoerdmullender

We support just about any name, as long as it is in double quotes.