nsdhami Posted January 18, 2008 Share Posted January 18, 2008 I am getting problem with inserting and selecting japanese data to/from MS-SQL 2005. For testing, I created table with two columns of varchar and nvarchar datatypes. So, when I tried to access column of nvarchar datatype, I got error messages as: "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." and When I tried to access column of varchar then, I got the data as "????????" instead of some japanese characters. I am using the mssql functions as mssql_connect(), ... function. I am in great trouble. Thanks in Advance. ??? Link to comment https://forums.phpfreaks.com/topic/86615-problem-with-mssql-and-php/ Share on other sites More sharing options...
Cep Posted January 18, 2008 Share Posted January 18, 2008 If your going to use Japanese chars you need to set your charset in your MSSQL instance to a Japanese character set otherwise your going to get odd characters instead of the ones you intend to see. Link to comment https://forums.phpfreaks.com/topic/86615-problem-with-mssql-and-php/#findComment-442610 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.