[MonetDB-users] UTF-8 for table/column names
Hi, Is there support for UTF8/Unicode for field/table names? It seems like i can only use ASCII characters (for example, a field name with specific Spanish letters wouldn't work) inside field/table names. I'm using the Nov09 on Windows. Thanks. -- View this message in context: http://old.nabble.com/UTF-8-for-table-column-names-tp26888868p26888868.html Sent from the monetdb-users mailing list archive at Nabble.com.
On 22-12-2009 06:04:58 -0800, Alex Bo. wrote:
Is there support for UTF8/Unicode for field/table names?
It seems like i can only use ASCII characters (for example, a field name with specific Spanish letters wouldn't work) inside field/table names.
have you tried quoting them?
Yes I have, for example: create table "gñÑ" (f1 int) returns: !Invalid identifier 'gñÑ' Fabian Groffen wrote:
On 22-12-2009 06:04:58 -0800, Alex Bo. wrote:
Is there support for UTF8/Unicode for field/table names?
It seems like i can only use ASCII characters (for example, a field name with specific Spanish letters wouldn't work) inside field/table names.
have you tried quoting them?
------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- View this message in context: http://old.nabble.com/UTF-8-for-table-column-names-tp26888868p26891603.html Sent from the monetdb-users mailing list archive at Nabble.com.
On 22-12-2009 09:36:45 -0800, Alex Bo. wrote:
Yes I have,
for example:
create table "gñÑ" (f1 int)
returns:
!Invalid identifier 'gñÑ'
Ok, I think this is because SQL99 forbids special chars in identifiers. I would have to check, but the big book is not within reach at the moment.
participants (2)
-
Alex Bo. -
Fabian Groffen