Jump to content


Photo

Unicode Support in PHP and MS SQL


  • Please log in to reply
2 replies to this topic

#1 meloks

meloks
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 10 October 2006 - 12:04 PM

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 data
to/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 webpage

Also, 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.






#2 argoSquirrel

argoSquirrel
  • Members
  • PipPipPip
  • Advanced Member
  • 36 posts

Posted 16 October 2006 - 10:16 PM

Appears to be a documented bug dating back to '02. http://bugs.php.net/bug.php?id=18169

Have you tried:

ADODB.Connection",NULL,CP_UTF8


#3 jastu

jastu
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 19 December 2006 - 02:52 PM

It`s my first post(in English) ..so be patient  ;)

I have the same problem with UTF-8 in PHP and MSSQL (and i can`t find solution) . If anybody working with this and know how can i use it together - i`ll be grateful.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users