Related Documentation Download this Manual Excerpts from this Manual


This page has moved or been replaced. The new page is located here:

Please update any bookmarks that point to the old page.

Download this Manual
User Comments
  Posted by Ross McKay on January 2, 2013
When accessing MySQL via ODBC from Classic ASP, you can get Unicode data when you specify charset=ucs2. If you try charset=utf8, you get garbled characters. The ODBC connection can use ucs2, and the page can still use the UTF-8 codepage and response charset.
  Posted by Rich Bianco on September 16, 2014
PROBLEM 1: Using PowerBuilder (or other tools) you may CRASH when selecting from a text column containing data with 4 byte UTF-8 chars.
SOLUTION: Change Character Set in ODBC, use utf8mb4 instead of utf8 (supported in MySql 5.5.3 or greater)

** More details:

Example Offending Data: ˌɛksɛnˈ
UTF-8 binary: 0xC9 0x9B (c99b)
UTF-8 hex: 11001001:10011011

PROBLEM 2: You may select TEXT columns but get empty results back.
WORKAROUND: Use substring(text_colname, 1, 10000) and you can get the data but this solution is more of a work around.
SOLUTION: In your ODBC settings window, in the Metadata tab, select: Limit column size to signed 32-bit range. You will be able to select TEXT columns!
** Also remember to use the Driver-Specific Parameters in PowerBuilder, use: IGNORE_SPACE=1;FLAG_SAFE=1;

  Posted by sub le Dub on April 9, 2015
In MS Access 2007, use USER and PASSWORD ,in uppercase, in your DSN file
The UID and PWD doesn't work for me..
Sign Up Login You must be logged in to post a comment.