[PHP] MSSQL 패키지 사용시 에러 - Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (severity 16)

Error Message:

Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (severity 16)       

 

1. /etc/php.ini에  mssql.charset = "UTF-8" 첨가

2. /etc/freetds.conf 에서

[global]

;tds version = 4.2

tds version=8.0

client charset = UTF-8

 

3. select * 의 사용을 줄이고 되도록이면

Select Cast(FIELD as text) as FIELD from...식으로 해준다.