PHP, ODBC, and nvarchar

Discussion

1. David

   THANKS!!!
   muchas gracias.. ahora puedo seguir trabajando tranquilo.. justamante estaba teniendo problemas con un campo nvarchar.
2. umberleigh

   Casting to varchar limits you to 8000 characters in a field.

   I found just casting to text works better, like so:

   print("SELECT CAST([column_name] AS TEXT) AS column_0 FROM table_name");
3. andy

   Thanks , nice solve problem from sql server
4. San

   Cast did the job ….

   Nice post !!!
5. mohi

   not work!

   Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near ‘ASâ’. (severity 15) in /var/www/vhosts/fvc.ir/httpdocs/mssql.php on line 11
6. OZ

   Thank you very very much!
   And here is how to write value:
   http://stackoverflow.com/questions/7255703/utf-8-in-sql-server-2008-database-php

   $value = 'ŽČŘĚÝÁÖ';
   $value = iconv('UTF-8', 'UTF-16LE', $value); //convert into native encoding 
   $value = bin2hex($value); //convert into hexadecimal
   $query = 'INSERT INTO some_table (some_nvarchar_field)  VALUES(CONVERT(nvarchar(MAX), 0x'.$value.'))';
   
7. Radu

   thanks a lot. i was not shure what was the problem. In the sql management studio the data looks fine and in php is not. my first impresion was user rights for the data .. but after 1 hour of hair pulling :) i wandered if culd be the odbc … and like this i found your post

   thanks again
8. Riyas

   Thanks for this solution. I was stuck at this problem and finally reached here