add unit tests for unicode columns with unicode foreign keys

Issue #729 resolved
Mike Bayer repo owner created an issue

i noticed that reflection.py UnicodeTest isnt testing reflection of foreign keys with unicode chars in them. considering all the bumps in the road the existing test revealed, we should add some tests for things like:

Column('測試_col', ForeignKey('測試_someothertable.測試_someothercolumn'))

with the chinese chars as well as the euro chars (different issues seem to arise with each).

Comments (6)

  1. Mike Bayer reporter
    • removed status
    • changed status to open

    added test_needs_fk to the tables, mysql fails most tests. it almost seems like mysql does not actually handle unicode schemas properly, nor does PG, including a bizarre issue where mysql wont delete from t3, even though no foreign keys reference t3!. this sounds unbelievable of course but i can't find anything wrong with what SA is sending.

  2. jek

    looks like this one needs >= 5.1.something for mysql, there's some issue with unicode foreign keys in innodb tables in previous versions.

  3. Log in to comment