$insert_val = “insert into [LightingDB].[dbo].[pendinglist] ( [Order_number] ,[Name],[phone],[vendor_address],[vendor_name],[product],[gender],[birthday] ,[order_date],[p_key_address],[payment_status]) values ($order_id,’$customer_name’,’$phone’,’$vendor_address’,’$vname’,’$product’,’$gender’,’$bdate’,’$order_date’,’$pkadr’,$payment_status)”;

This is work with english data but when i put chinese data in it, this is showing error as below:

Warning: mssql_query(): message: Incorrect syntax near ‘77777777’. (severity 15) on line 1068

Warning: mssql_query(): General SQL Server error: Check messages from the SQL Server (severity 15) in line 1068

Warning: mssql_query(): Query failed line 1068

Please anyone can Help me out from here.


Read more here: how to insert Chinese value in mssql using php


If you know the solution of this issue, please leave us a reply in Comment section, to update the question.

Wordpress related questions and answers: