Menu

#67 Solution for DB-independent connection charset and collation

6.1
open
Back-end (42)
5
2014-08-26
2009-07-08
No

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.

Discussion

  • Anonymous

    Anonymous - 2009-07-08
    • labels: --> Back-end
    • assigned_to: nobody --> gsolt
     
  • Gustavo Solt

    Gustavo Solt - 2009-08-24
    • milestone: --> 899257
     
  • Gustavo Solt

    Gustavo Solt - 2010-03-03
    • milestone: 899257 --> 6.1
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.