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 [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.
