mssql and latin characters

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux