|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0001177||v3.0 Release||[All Projects] General||public||2012-08-21 04:31||2013-08-28 11:18|
|Target Version||Fixed in Version||3.0.0|
|Summary||0001177: MySQL servers with incorrect charset might break object integrity + proposed fix|
|Description||I just encountered this in EasyPHP 12.0.0's default configuration.|
The default charset for MySQL connections is latin1 in EasyPHP and this caused values containing æøå (presumably other similar characters) to appear as the infamous ?.
In my case this is a pretty severe flaw as these characters doesn't pass either JSON or TBS (http://www.tinybutstrong.com) validation and caused several issues in my JS and several module templates.
According to Stack Overflow a "SET NAMES utf8" query before any other queries will fix this for people who do not have access to the MySQL settings... Maybe running this query as soon as a connection is established in the w2p_Database_Qeury class is a good idea to ensure consistent behavior independent of platforms and configurations?
|Tags||No tags attached.|
Please let me know if this works as expected:
|2012-08-21 04:31||Korkonius||New Issue|
|2012-11-21 21:50||caseydk||Note Added: 0002697|
|2012-11-21 21:50||caseydk||Status||new => resolved|
|2012-11-21 21:50||caseydk||Resolution||open => fixed|
|2012-11-21 21:50||caseydk||Assigned To||=> caseydk|
|2013-08-28 11:14||caseydk||Fixed in Version||=> 3.0.0|
|2013-08-28 11:18||caseydk||Status||resolved => closed|