[sqlalchemy] Elixir: Enum and accented characters (non-ASCII character)

[Pierre Bossé]

Hello,

Here is my problem:

I would define a domain of values ​​for a table field. Some values ​​
have accented characters (non-ASCII character).

When generating the DDL for Elixir, a conversion is made on the
values ​​provided by the accented characters and no longer.

Here is my test code:
============================================================
# -*- coding: iso-8859-1 -*-

from elixir import *

class TestEnum(Entity):
    myEnum = Field(Unicode(100),\
         Enum(u'avec é',
              u'avec è',
              u'avec à'),\
         colname='MY_ENUM')

if __name__ == '__main__':
    metadata.bind = 'oracle://..:..@..'
    metadata.bind.echo = True

    setup_all()
    drop_all()
    create_all()
============================================================


Here is the generated DDL:
============================================================
CREATE TABLE "__main___testenum" (
    id INTEGER NOT NULL,
    "MY_ENUM" NVARCHAR2(100),
    PRIMARY KEY (id),
    CHECK ("MY_ENUM" IN ('avec é', 'avec è', 'avec à'))
)
============================================================

By correcting the DDL by hand and creating the table, everything is in
the Oracle DB is correct.

Is there a configuration setting that would correct this situation??

Maybe a bug with Elixir??

Thank you for your answers.

-- 
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 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.