tracker issue : CF-4154053

select a category, or use search below
(searches all categories and all time range)
Title:

MySQL DD corrupts UTF-8 data / MySQL 5 does not

| View in Tracker

Status/Resolution/Reason: To Track//ThirdParty

Reporter/Name(from Bugbase): e-domizil License Team / e-domizil License Team (Alexander Hass)

Created: 05/17/2016

Components: Database

Versions: 2016

Failure Type: Data Corruption

Found In Build/Fixed In Build: CF2016_Final /

Priority/Frequency: Major / All users will encounter

Locale/System: ALL / Win 2012 Server x64

Vote Count: 0

Problem Description: We have an UTF8 database on mysql Ver 14.14 Distrib 5.1.46sp1, for Win32 (ia32)

Steps to Reproduce:

1. Configure MySQL DD (data direct) with this mysql server
2. Run selects with German special chars in the database.

Adding "useUnicode=true&characterEncoding=UTF-8" to the connection does not help.

Actual Result: Corrupted utf8 chars.

Expected Result: No corrupted chars

Any Workarounds:

1. You can add "SET NAMES utf8;" on top of every query. Not really an option to us.
2. Install MySQL 5 driver and change the DSNs.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4154053

Reason:	PRHaveInfo

External Customer Info:
External Company:  
External Customer Name: Firstname Lastname
External Customer Email:  
External Test Config: My Hardware and Environment details:

Attachments:

Comments:

Please try using below mentioned connection property and see if it works: CodePageOverride=UTF8 Please make sure you are trying it on your testing environment only.
Comment by Nimit S.
2777 | May 30, 2016 12:20:14 AM GMT
Tried it with below Connection String's, but no success. 1. CodePageOverride=UTF8 2. useUnicode=true&characterEncoding=UTF-8&CodePageOverride=UTF8 3. useUnicode=true&characterEncoding=UTF-8&CodePageOverride=UTF-8 All non ascii chars are still broken.
Comment by External U.
2778 | May 30, 2016 03:25:36 AM GMT