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
diacriticals... I dunno if it would allow table names with those, though...
Also, with quotes you can get a lot of weird things (such as spaces in column
names).
This is for PostgreSQL:
# create table weird_test ("column test" serial, "é um teste" varchar);
NOTA: CREATE TABLE criará sequência implícita "weird_test_column test_seq"
para coluna serial "weird_test.column test"
CREATE TABLE
# \d weird_test
Tabela "public.weird_test"
Coluna | Tipo | Modificadores
-------------+-------------------+--------------------------------------------------------------------
column test | integer | not null default nextval('"weird_test_column
test_seq"'::regclass)
é um teste | character varying |
# select * from weird_test ;
column test | é um teste
-------------+------------
(0 registros)
# insert into weird_test ("é um teste") values ('testing 123');
INSERT 0 1
# select * from weird_test ;
column test | é um teste
-------------+-------------
1 | testing 123
(1 registro)
#
So, if you don't use quotes you're a lot more restricted than with quotes. I
dunno, though, who would be crazy to create such names.
--
Jorge Godoy <[EMAIL PROTECTED]>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
