0
I have the error above when hosting on Locaweb’s linux server. System was developed in Laravel and the sql server database 2008.
SQLSTATE[HY000]: General error: 4004 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.
The error occurs only when staying. Someone can help me?
This error has been fixed on the following link: https://stackoverflow.com/questions/5414890/mssql-query-issue-in-php-and-querying-text-data
– Luan Lary
Thank you for the answer. The problem is that this occurs only when hosted on the Ocaweb server. With this, I can not change the version, IE, I need to change this version on the hosting server and not on my machine.
– Gustavo Nascimento
Take a look here https://stackoverflow.com/questions/46437112/laravel-mssql-aws-rds-general-error-20018-unicode-data
– Marcos Xavier
Thanks for the help, but it didn’t work. I use the proper authentication mode, so I can’t change the sql query. I continue with the problem, unfortunately.
– Gustavo Nascimento
I solved the problem as follows. I asked the host to change the TDS version. They changed it and the error stopped occurring.
– Gustavo Nascimento