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 sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---