Getting data with UTF-8 charset from MSSQL server using PHP FreeTDS extension

by

I had a similar problem and tried all settings i could find on the web – in vain.

In my case the problem was the configuration of FreeTDS itself. On Linux the file is /etc/freetds/freetds.conf

I had to change the Version to 7.0 (maybe other numbers work, too. i just tried 7.0)

[global]
    # TDS protocol version
    tds version = 7.0

After this, the driver seemed to accept changes of the charset like. 

ini_set('mssql.charset', 'UTF-8');

Btw: the change immediately is in effect, no need to restart anything afterwards

More Related Contents:

  1. “Adaptive Server is unavailable or does not exist” error connecting to SQL Server from PHP
  2. SQL Server error 1934 occurs on INSERT to table with computed column PHP/PDO
  3. How to decode Unicode escape sequences like “\u00ed” to proper UTF-8 encoded characters?
  4. How can I output a UTF-8 CSV in PHP that Excel will read properly?
  5. How to remove multiple UTF-8 BOM sequences
  6. How do I use filesystem functions in PHP, using UTF-8 strings?
  7. How to remove all non printable characters in a string?
  8. PHP: Convert any string to UTF-8 without knowing the original character set, or at least try
  9. MySQL and PHP: UTF-8 with Cyrillic characters [duplicate]
  10. Fixing broken UTF-8 encoding
  11. PHP Fatal error: Call to undefined function mssql_connect()
  12. Connect PHP to MSSQL via PDO ODBC
  13. Convert utf8-characters to iso-88591 and back in PHP
  14. PHP: Convert unicode codepoint to UTF-8
  15. can I get the unicode value of a character or vise versa with php?
  16. is PHP str_word_count() multibyte safe?
  17. How to connect sql server with php using xampp?
  18. ‘Malformed UTF-8 characters, possibly incorrectly encoded’ in Laravel
  19. strlen() and UTF-8 encoding
  20. How to skip invalid characters in XML file using PHP
  21. Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs
  22. How can I sort an array of UTF-8 strings in PHP?
  23. PHP json_encode json_decode UTF-8
  24. Ensuring valid UTF-8 in PHP
  25. UTF-8 in PHP regular expressions [duplicate]
  26. fwrite() and UTF8
  27. The ultimate emoji encoding scheme
  28. Get Return Value from SQL Stored Procedure using PHP
  29. UTF8 Filenames in PHP and Different Unicode Encodings
  30. How do I detect if have to apply UTF-8 decode or encode on a string?

Leave a Comment