[sqlalchemy] Re: How to deal with non-ASCII(such as Chinese)table name?

2007-03-27 Thread Chen Houwu
I mean non-ascii column names defined in my database table. SqlServer, Oracle, MySql...all of the mainstream DBMS support this feature, In east asia(China, Japan, Korea), non-ascii column names and table names,together with non-ascii strings in record are widely used. On 3月25日, 下午10时55分, Michael

[sqlalchemy] Re: How to deal with non-ASCII(such as Chinese)table name?

2007-03-27 Thread Chen Houwu
But following the second post (see below), I have read the documentation, though not very carefully, and have not validated it by test code, but the documentation really shows the solution to my problem. Have I misunderstood the documentation? -- second post

[sqlalchemy] Re: How to deal with non-ASCII(such as Chinese)table name?

2007-03-27 Thread Chen Houwu
from the docstring in class Column: def __init__() name The name of this column. This should be the identical name as it appears, or will appear, in the database. key Defaults to None: an optional alias name for this column. The column will then be identified everywhere

[sqlalchemy] Re: How to deal with non-ASCII(such as Chinese)table name?

2007-03-27 Thread sdobrev
On Tuesday 27 March 2007 18:12:37 Chen Houwu wrote: from the docstring in class Column: def __init__() name The name of this column. This should be the identical name as it appears, or will appear, in the database. key Defaults to None: an optional alias name

[sqlalchemy] Re: How to deal with non-ASCII(such as Chinese)table name?

2007-03-27 Thread Michael Bayer
I am doing some experimenting with this, and it would appear that Psycopg2 (not sure about postgres itself) can not handle unicode column names. sqlite and mysql adapters do handle unicode table and column names. so in changeset 2447, I have made some adjustments so that unicode table

[sqlalchemy] Re: How to deal with non-ASCII(such as Chinese)table name?

2007-03-25 Thread Jorge Godoy
Michael Bayer [EMAIL PROTECTED] writes: non-ascii attribute names in your Python code ? or non-ascii column names defined in your database table ? I didnt know the latter was possible with most databases. I know that (ARGH!) MySQL would allow the latter. I've seen column names with

[sqlalchemy] Re: How to deal with non-ASCII(such as Chinese)table name?

2007-03-25 Thread Paul Johnston
Hi, Unicode characters in table/column names is fully supported by MSSQL. Paul Michael Bayer wrote: non-ascii attribute names in your Python code ? or non-ascii column names defined in your database table ? I didnt know the latter was possible with most databases.

[sqlalchemy] Re: How to deal with non-ASCII(such as Chinese)table name?

2007-03-25 Thread Michael Bayer
yah but thats just MS-SQL who cares :) On Mar 25, 2007, at 4:12 PM, Paul Johnston wrote: Hi, Unicode characters in table/column names is fully supported by MSSQL. Paul Michael Bayer wrote: non-ascii attribute names in your Python code ? or non-ascii column names defined in your

[sqlalchemy] Re: How to deal with non-ASCII(such as Chinese)table name?

2007-03-24 Thread sdobrev
try Column()'s parameters quote=.. and key=.., doc/docstrings.html#docstrings_sqlalchemy.schema_Column and/or mapper's explicit column-naming: doc/adv_datamapping.html#advdatamapping_properties_colname On Sunday 25 March 2007 08:04:02 Chen Houwu wrote: from the sqlalchemy documentation, I