Please, see also this MySQL bug report for some more details: http://bugs.mysql.com/31279
Assume you have a table with an integer column f.e. table "cds" from "cdcol" sample database.
Executing the following statement truncates result to 3 chars:
SELECT DISTINCT CAST('jahr' as CHAR) FROM 'cds'
--> replace 'jahr' with 'year' in english version
This problem does not appear on unix based mysql database server. It did not occur just 1 Month ago. There might have been a windows update in the last 4
weeks that causes this problem.
The problem also does not occur when executing "SELECT CAST('jahr' as CHAR) FROM 'cds'" or
"SELECT DISTINCT CAST('jahr' as CHAR(4)) FROM 'cds'"
Furthermore, it does not occure if using the MySQL command line client.
The fact, that phpMyAdmin as well as self-written .NET applications using MySQL Connector/NET 5.1.2 are affected seems somehow strange.