PHP + SQL Server – How to set charset for connection?

by

Client charset is necessary but not sufficient:

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

I searched for two days how to insert UTF-8 data (from web forms) into MSSQL 2008 through PHP. I read everywhere that you can’t, you need to convert to UCS2 first (like cypher’s solution recommends).
On Windows SQLSRV said to be a good solution, which I couldn’t try, since I am developing on Mac OSX.

However, FreeTDS manual (what PHP mssql uses on OSX) says to add a letter “N” before the opening quote:

mssql_query("INSERT INTO table (nvarcharField) VALUES (N'űáúőűá球最大的采购批发平台')", +xon);

According to this discussion, N character tells the server to convert to Unicode.
https://softwareengineering.stackexchange.com/questions/155859/why-do-we-need-to-put-n-before-strings-in-microsoft-sql-server

More Related Contents:

  1. strange character encoding of stored data , old script is showing them fine new one doesn’t
  2. How to connect to mssql using pdo through PHP and Linux?
  3. Laravel one to many relation with a one to one relation
  4. Is it ” RTSi6+yxLwIW7KsnoehVDA== ” md5? or How to get original string? [closed]
  5. save user images in MYSQL database by which method? [closed]
  6. PDO get the last ID inserted
  7. How to replace Microsoft-encoded quotes in PHP
  8. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  9. Importing CSV data using PHP/MySQL
  10. Setting the PHP default encoding to UTF-8
  11. Convert latin1 characters on a UTF8 table into UTF8
  12. Notice: Array to string conversion in
  13. Inserting data to table (mysqli insert) [duplicate]
  14. UTF-8 encoded html pages show � (questions marks) instead of characters
  15. PDO::PARAM for type decimal?
  16. Generating a single Entity from existing database using symfony2 and doctrine
  17. Selecting a float in MySQL
  18. How to use special characters in recipients name when using PHP’s mail function
  19. Storing database connection in a session variable [duplicate]
  20. How can I refresh a page when a database is updated?
  21. Detect file encoding in PHP
  22. UTF-8 safe equivalent of ord or charCodeAt() in PHP
  23. Replacing invalid UTF-8 characters by question marks, mbstring.substitute_character seems ignored
  24. mysql injection damages?
  25. looping a SQL insert statement with dates
  26. Auto Increment skipping numbers?
  27. UTF-8 not working in HTML forms
  28. How to get last inserted id from table MySQL [duplicate]
  29. json_encode produce JSON_ERROR_UTF8 from MSSQL-SELECT
  30. Decoding numeric html entities via PHP

Leave a Comment