Hi I have an application with Apache/1.3.20 (Win32), PHP/4.0.6 and SQLServer7.
My problem is when I write accents in a form to send to insert into the database. They encode to very strange symbols.
I proved to write the code of the passed field from the form in php and it writes right.
code: print"$salva";
result: áéíóúàèìòùÁÉÍÓÚÀÈÌÒÙ
But when I take the data from the database it write almost chinese.
code:
$result = mssql_query("select salva from salva where id_salva=(select max(s.id_salva) from salva s)");
$data = mssql_fetch_row($result);
$valor = $data[0];
print"$valor";
result: áéíóúàèì=ù-+-Ó+++ÝÒ+
data in the sqlserver:ßÚݾ·ÓÞý=¨-+-Ë+++¦Ê+
So I think than the problem is in the mssql.dll library of the php and not in the apache or sqlserver.
I'm using the AddCharset ISO-8859-1
thanks
Some ideas??