且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Linux 上的 PHP 5.4:如何连接 MS SQL Server 2008?

更新时间:2022-05-18 22:56:15

我的问题的答案是:使用 freeTDS!上面有一个字符集参数:

The answer for my question is: Use freeTDS! Theres a parameter for charset on it:

[MyDSN]
    host = <<ip>>
    port = <<port>>
    # use 8.0 for newer versions of SQLSERVER
        tds version = 8.0
        # text size don't need to be such a high value, its just an example
        text size = 4294967295
        client charset = UTF-8

在 Zend Framework 上,像这样配置您的连接:

On Zend Framework, configure your connection like this:

;; BANCO DE DADOS LINUX
database.adapter                = PDO_MSSQL
database.params.pdoType         = dblib

database.params.host            = MyDSN
database.params.dbname          = <<dbname>>
database.params.username        = <<username>>
database.params.password        = <<passwd>>
database.params.driver_options.charset = UTF-8

database.isDefaultTableAdapter  = true

它解决了问题!;)