- labels: --> Back-end
- assigned_to: nobody --> gsolt
We need a solution to make Zend_Db configure the database connection correctly so that it uses UTF-8.
This issue has been addressed in the Zend Framework with changeset 14691, see http://framework.zend.com/code/changelog/Zend_Framework?cs=14691
This is published with ZF version 1.8.0.
A list of methods top deal with different databases is at http://framework.zend.com/issues/browse/ZF-1541;jsessionid=BB7F5E5D1B9326B21B0B16F52BE1871B?page=com.atlassian.jira.ext.fisheye:fisheye-issuepanel
Earlier versions of ZF do not allow to use a single method of configuring the db connection, but would need to use an individual solution for each db driver.
Also, there should be a method to select the proper collaction for the database. This affects sorting. The current setup method only supports MySQL, and only allows utf8_general_ci as a collation. This works for the english and german language, but there must be a reason that utf8_spanish_ci exists. The collation for the database should be selected based on the default language that is used with P6.