RE: Visio Reverse Engineer - Character Set
"Jerry Schwartz" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
> -----Original Message----- > From: Mont McAdam [mailto:[email protected]] > Sent: Wednesday, January 23, 2008 9:00 PM > To: [email protected] > Subject: Visio Reverse Engineer - Character Set > > 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. [JS] Version 3.51 of the ODBC connector does not handle UTF8 characters. Try version 5.x. -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]