/dev/null

Elite is stupid. Back to the roots.

May 31, 2007

Zend Framework: Unicode DB adapter for SQL Server

Tags: — 13:26

Yeah, I finally got it managed to publish my proposal for the Zend Framwork ODBTP database adapter component:

http://framework.zend.com/wiki/display/ZFPROP/Zend_Db_Adapter_Odbtp_Mssql

The default MS SQL database driver does not work with Unicode, as SQL Server expects Unicode strings in the UCS-2 encoding (UCS-2 contains null bytes and the driver is not binary-safe). ODBTP works as layer between PHP and SQL Server and accepts Unicode strings in the UTF-8 encoding.

The required classes are attached bellow. Feel free to download, use and test them! Please note that they *might* need to be adapted for the latest framework release.

I also wrote an article about multi-lingual enterprise applications for the German PHP Magazine. Hope it will be published in the next issue.

2 Comments »

  1. But where are the sources ?

    Comment by Laurent — May 19, 2008 @ 14:28

  2. It’s good to hear that somebody’s asking for them ;)

    I’ll upload them to this blog during the next days! The sources on framework.zend.com are outdated.

    Comment by Michael — May 19, 2008 @ 14:33

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by PHP, Memcached, Suhosin, MySQL and WordPress