Bug #14487 Updated: Problem with stressed charachter (like É or Ó

ID: 14487 Comment by: fjortiz@comunet.es Old Reported By: s.vigni@hor-net.com Reported By: fjortiz@comunet.es Status: Open Bug Type: MSSQL related Operating System: win NT 4.0 sp5 PHP Version: 4.0.6 New Comment: We work with Spanish databases and had the same problem: try this: Start Menu\Programs\Microsoft SQL Server\Client Network Utility. Then uncheck the "ANSI to OEM conversion" and restart the web server. This worked for us. Previous Comments: ------------------------------------------------------------------------ [2001-12-13 10:50:09] s.vigni@hor-net.com I have an MSSQL Server 2000 with a database with users data. some of this names a re frenche name with stressed charachter in. When i execute queries via odbc i have no problems and everything works fine, using MSSQL native functions doesn't work, instead of the stressed character i get some unreadable simbol. The webserver runs on a machine and the SQL server on another, the link is made via TCP protocol (i don't know if via named pipe works, but i doubt), on the client machine (the webserver) is installed only the client of SQL2000. I'm using Apache 1.3.20+modssl/php 4.0.6 on winnt 4 sp5 and the php_mssql.dll extension loaded. PHP is run as CGI not as a module. I believe there is some problems in the way php_mssql.dll handles data. ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=14487&edit=1