更新时间: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
它解决了问题!;)