Visio Reverse Engineer - Character Set

Some more info I have just thought to provide is that MySQL server is on
remote linux machine, not local on windows box.


-----Original Message-----
From: Mont McAdam 
Sent: Thursday, 24 January 2008 1: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.

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]