Bug #58094 MS Access ODBC DSN-Less connection displays wrong characters
Submitted: 9 Nov 2010 20:07 Modified: 11 Aug 2011 12:12
Reporter: Justin Ram Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:5.5 OS:Windows (X86 & X64)
Assigned to: Bogdan Degtyariov CPU Architecture:Any
Tags: 5.1, 5.5, character sets, Latin1, MS Access

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[9 Nov 2010 20:08] Justin Ram
bad characters of same view of table

Attachment: badcharacters-vba odbc.jpg (image/jpeg, text), 487.94 KiB.

[9 Nov 2010 20:10] Justin Ram
good characters of same view of table

Attachment: goodcharacters-ODBCLinkManager.jpg (image/jpeg, text), 250.04 KiB.

[24 Jan 2011 15:36] Dan Rosauer
Screen shot of the same MySQL view displayed correctly in MySQL and with Chinese characters via an OBDC link in Ms Access 2007

Attachment: MySQL-Access_characterset_bug.PNG (image/png, text), 191.73 KiB.