#18169 [Com]: Driver cannot deliver UCS-2 unicode to SQL Server

ID: 18169 Comment by: giannisptr at yahoo dot gr Reported By: joesterg at hotmail dot com Status: No Feedback Bug Type: MSSQL related Operating System: Windows 2000 Server PHP Version: 4.1.2 New Comment: Has anyone found a solution to the encoding problem????? I am using a web service to get a string of data from an sql server 2000 database. When i invoke the web service from php, greek characters are replaced by character '?'. Previous Comments: ------------------------------------------------------------------------ [2006-09-21 06:59:28] gautam dot webprogram at yahoo dot com I want to connect php with MS SQL Server 2000 I have used the folloing code in PHP: <? $connection = mysql_connect ("localhost","user name","password"); if (!$connection) { echo "Couldn't make a connection!"; exit; } ?> The code doesn't execute. ------------------------------------------------------------------------ [2006-09-09 01:18:11] aireater at gmail dot com I still have the same issue with the latest Windows binary 5.1.6 and MS SQL Server 2005 Express, Standard, Enterprise on Windows XP, 2003 Server. It never works. ------------------------------------------------------------------------ [2006-04-20 01:24:43] timdilbert at gmail dot com Just out of curiousity I was wondering if this was fixed in PHP5 and MSSQL 2005?? I haven't tried using COM just yet, but I will be when I get home (on MSSQL 2000). But I was having the same problem with PHP5 and inserting UTF-8 encoding into MSSQL Server 2000. I will post if this fixed my problem. If not, I'm really sorry guys.. I love PHP, but I might be be rebuilding my entire site is C# because Unicode support is absolutly vital to our company and success. ------------------------------------------------------------------------ [2004-04-15 06:07:34] samlinxp at msn dot com I have the same problem. My setup is: Windows XP Server, with Apache 2.0.47/PHP 4.3.6RC3 and Microsoft SQL Server 2000 Hope this problem can be solved soon. This is quite important especially at Asia Pacific's regions (CHN, HK, TW, JP, KR.. etc) ------------------------------------------------------------------------ [2003-06-29 21:33:00] iliaa@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/18169 -- Edit this bug report at http://bugs.php.net/?id=18169&edit=1