mssql + php + spanish = can't retrieve especial spanish characters

sergarbes

Hi all !

I'm developing a Web Aplication with PHP and SQL Server in spanish and I've problems retrieving fields from the database that have specific spanish characters like words with vowel stress like "camión"

When I retireive a field having such a word I obtain some strange ascii characters.

I execute the queries via mssql functions proveided for the PHP environment.

Does anybody knows if such functions are only usefull for english ?

I've also tried to create a table form SQL Server for the spanish langauge and having all the available opstion and it also doesn't work.

Can anyone help me ?

Thanks

Excuse me for my writen english ;-)

kumschick

I'm sorry, but if I add the value "camión" into a field in mysql and i make a "select * from ..." i get the value back the same why I put it in.

What could help, try to add the <html> code in the meta tag

then i should work 🙂 but i'm not sure....

sergarbes

Thank you kumschick, but the database I'm using isn't mysql it's Microsoft SQL Server (mssql)

MySQL works fine as you explane, but I don't know what happends with Microsoft SQL Server.

The problem here is that for some circumtances we have to use that database instead of MySQL ;-)

kumschick

So you are also Running Windows NT/2000/2003 Server.
Is the server in your network, or do you connect on a server on the web.

Cause I know with Microsoft, if the OS is installed in an other language with special caraters like Russian, or any Asien Language you get problems like that!

It has to do with the ISO.

Try this, you may need to update the scipt:

<?php
function cyrconvert($thestring) {

$specialchars = array(
"÷" => "ch",
"×" => "CH",
"ø" => "sh",
"Ø" => "SH",
"ù" => "sht",
"Ù" => "SHT",
"þ" => "iu",
"Þ" => "IU",
"ÿ" => "q",
"ß" => "Q");

$translate = strtr($thestring, "àáâãäåæçèéêëìíîïðñòóôõöúÿÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÚß", "abwgdevziiklmnoprstufhcuqABWGDEVZIIKLMNOPRSTUFHCUQ");
$translate = strtr($translate, $specialchars);
return $translate;
}

$teststring = "Òóê èìàìå íÿêàêúâ òåêñò íà áúëãàðñêè åçèê ...";
echo "Originalen tekst: ". $teststring ." ";
echo "Konvertiran tekst: ". cyrconvert($teststring);
?>

Tell me if it helped you!

sergarbes

Many thanks for the script ;-)

It helped me a lot and It's a useful way to solve the problem.

Anwering one of your questions, I've the database server on my network. For the moment I'm going to use your idea, but I'm also going to revise the setup of the server.

SGB

kumschick

I'm happy that this code could help you, I was not sure if it would work with spanish. 😃

Did you need to change something on the code? Or did it imediatly work with the spanish languge?

sergarbes

Well, I've to change some characters to match the ones I get when an "à, á, è ..." is retrieved in a wrong way by some reason.

Al last I decided to investigaste my problem with mssql functions and the client library for mssql and I noticed that with connecting with the database via an ODBC I'm able to retrive the expected characters ;-)

But I still thinking what's wrong with the mssql functions ...

Thanks !

leatherback

Originally posted by sergarbes
But I still thinking what's wrong with the mssql functions ...

Thanks !

I suppose it is the MS part which is wrong with them 😃