mssql and latin characters

Hello I have a MSSql 2000 database that have stored data with the follow special characters: ó, í, Ñ, á, é, ú. When I see the data through any MsSql Client I see exactly those characters. The Collation of database is: SQL_Latin1_General_CP1_CI_AS I can’t change the method of insert data in database. When I get (with MSSQL PHP extension) data that have some of those characters, I get weird characters instead. For example: A data that in database appears as “Girón” is obtained by PHP as “Gir¢n” The problem with the encoding of browser is discarded, because wherever I saw the data appears with weird characters. The code I use to get the data is: <?php mssql_connect('server','user','pass'); mssql_select_db('db'); $r = mssql_query(“select some_column from some_table”); $d = mssql_fetch_assoc($r); echo $d['some_column']; ?> My PHP is 4.4.3, and my SO is XP. Other people ask the same as I’m and get no answer proper are: <http://www.psicofxp.com/forums/desarrollo-web.264/226703-php-mssql-y-acento s.html> http://www.psicofxp.com/forums/desarrollo-web.264/226703-php-mssql-y-acentos .html <http://www.bdat.net/cuestiones_php/php3/0702.html> http://www.bdat.net/cuestiones_php/php3/0702.html <http://www.forosdelweb.com/f18/problemas-con-caracteres-especiales-acentos- php-mssql-server-364345/> http://www.forosdelweb.com/f18/problemas-con-caracteres-especiales-acentos-p hp-mssql-server-364345/ <http://markmail.org/message/7rksvz44sj2te5sl> http://markmail.org/message/7rksvz44sj2te5sl <http://www.phpbuilder.com/board/archive/index.php/t-10208269.html> http://www.phpbuilder.com/board/archive/index.php/t-10208269.html Thanks in advanced. Leticia Larrosa __________________________________________ Participe en Universidad 2008. 11 al 15 de febrero del 2008. Palacio de las Convenciones, Ciudad de la Habana, Cuba http://www.universidad2008.cu