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. ??? Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.