Zend Framework: Unicode DB adapter for SQL Server
Yeah, I finally got it managed to publish my proposal for the Zend Framwork ODBTP database adapter component:
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.