| Leticia Larrosa 2008-01-21, 4:04 am |
| Hello
I have a MSSql 2000 database that have stored data with the follow =
special
characters: =F3, =ED, =D1, =E1, =E9, =FA.=20
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=92t 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:=20
A data that in database appears as =93Gir=F3n=94 is obtained by PHP as =
=93Gir=A2n=94
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 =3D mssql_query(=93select some_column from some_table=94);
$d =3D mssql_fetch_assoc($r);
echo $d['some_column'];
?>
My PHP is 4.4.3, and my OS is XP.
Other people ask the same as I=92m and get no answer proper are:
http://www.psicofxp.com/forums/desa...p-mssql-y-acen=
tos
..html
http://www.bdat.net/cuestiones_php/php3/0702.html=20
http://www.forosdelweb.com/f18/prob...eciales-acento=
s-p
hp-mssql-server-364345/=20
http://markmail.org/message/7rksvz44sj2te5sl=20
http://www.phpbuilder.com/board/arc...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
|