I need schema support and "it works at all" support in MySQL, so I had to change these things. It was'n't "character_Set_results" it was "character_set_results". The older MySQL 4? doesn't have this value at all. Hopefully I will be fully upgraded in a few weeks.
MySQL 4.0.24: show variables like 'char%'; | character_set | latin1 | character_sets | latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin1_de latin2 latin5 sjis swe7 tis620 ujis usa7 win1250 win1251ukr win1251 | The "table exists" function sucks. Is raising an error necessarily catastrophic here? Index: lib/sqlalchemy/databases/mysql.py =================================================================== --- lib/sqlalchemy/databases/mysql.py (revision 2550) +++ lib/sqlalchemy/databases/mysql.py (working copy) @@ -367,7 +367,13 @@ # i have tried dozens of approaches here with no luck. statements like # DESCRIBE and SHOW CREATE TABLE work better, but they raise an error when # the table does not exist. - cursor = connection.execute("show table status like %s", [table_name]) + if schema: # dwh MySQL schema hack... + default = connection.execute("select database()").fetchone()[0] + connection.execute("USE %s" % schema) + cursor = connection.execute("show table status like %s", [table_name]) + connection.execute("USE %s" % default) + else: + cursor = connection.execute("show table status like %s", [table_name]) return bool( not not cursor.rowcount ) def reflecttable(self, connection, table): @@ -377,7 +383,7 @@ cs = cs.tostring() case_sensitive = int(cs) == 0 - decode_from = connection.execute("show variables like 'character_Set_results'").fetchone()[1] + decode_from = connection.execute("show variables like 'character_set_results'").fetchone()[1] if not case_sensitive: table.name = table.name.lower() --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---