Visio Reverse Engineer - Character Set
"Mont McAdam" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <2D5263A9F1AEF744A8D900DE8A1799DF53A8@wiggum.syd01.office.plat.net.au.local> |
Hey all, I have just installed the ODBC connector version 3.51 into Windows Vista I am trying to use reverse engineer through Visio 2007, but having an odd problem. Essentially in the import wizard it is showing me the tables from the target database in what appear to be asian characters of some sort, but the first character of every table name is the correct character. Import completely fails with error: ------------------------------------- Extracting columns of table 'a鲍B'. Error! Cannot extract column definition for the table/view 'a鲍B'. The definition is not available or you may not have sufficient privileges. Please check with your database administrator. ------------------------------------- I have manually set the character type on that table which real name is "accounts" to utf8 collation=utf8_general_ci and set the default character set in ODBC DSN to utf8. Any thoughts? Or idead on how I might debug... Thanks in advance Mont -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]