meloks Posted October 10, 2006 Share Posted October 10, 2006 We are using PHP 5.1.6, MS SQL 2000 and ADO (PHP COM object) as connection.The issue we are trying to resolve is to correctly save and retrieve Cyrrilic datato/from database using Web Inteface, as well as to be able to retrieve data using MS SQL DTS tool.The data type in database is defined as nvarchar and character set on webpage defined as UTF-8. If database connection is established as $ado=new COM ("ADODB.Connection"),the Cyrrilic data is stored correctly to database, but has no meaning on webpage,and if connection is established as $ado=new COM ("ADODB.Connection",NULL,CP_UTF8),data is displayed correctly on webpage, but looks as garbage in database.We believe, the problem is that UTF-8 encoding is not supported in SQL Server and UCS-2 (SQL Server Unicode encoding) is not supported in webpage. So in case where we specified code page in connection as UTF-8, the data was stored as a sequece of characters and when read back from database, was interpreted correctly on webpageAlso, we have tried PHP "mb_convert_encoding" and "iconv" functions (mb_convert_encoding($string,'UTF-8','UCS-2'); iconv('UCS-2','UTF-8',$string);)to convert data betweeen different encodings, but it was not working properly.Is there any ideas on how it can be resolved?Many thanks. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.