The MSSQL dblib (used in the mssql extension) detects the codepage of the environment it is running under.
Caling a php script with php.exe can be done in at least 3 ways: 1) From IIS as CGI- this sets the codepage to 125x (ANSI) 2) From a command line - this sets the code page to 437 or whatever is the default on yoyr system 3) From IIS as FastCGI - this sets the code page to 437 or whatever is the default on yoyr system I think it wold be possible to change the FastCGI manager to launch php.exe the same way IIS does and have it working with ANSI codepage. I'm going to have a look at this. Disabling the automaitc ANSI to OEM does fix this problem. Codepage 1252 and ISO-8859-1 is the same thing. - Frank > Thanks for your answer Melih. > I think both charsets are correct, I simply deactivated the automatic ANSI > to OEM conversion in the Client Network DB Library of mssql and all works > fine now... please, how can I check the character sets in both PHP & MSSQL? > I think in MSSQL have set de code page 1252, and in PHP.INI i've set the > charset to ISO-8859-1. > > Thanks, > Xavier Serna. > > "Melih Onvural" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Are you sure that your character set is correct in both PHP and the MSSQL? > There was a big discussion about correctly setting the right code-type on > another PHP list that I'm on, and the ultimate outcome was that some > characters refuse to communicate between programs simply because their > encodings are different. Just a thought, > > > > melih > > > > > > From: "Xavier Serna" <[EMAIL PROTECTED]> > > > Date: 2003/06/26 Thu AM 10:58:42 EDT > > > To: [EMAIL PROTECTED] > > > Subject: [PHP-WIN] FastCGI & PHP 4.3.1 & MSSQL & IIS5 problem :( > > > > > > > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
