PHP + Apache + MsSQL + Swedish = "#¤%#

[asmodean]

Have been trying to make PHP understand swedish characters.

If i have swedish chars in my PHP code (as Headings or plain text) it works great, but when i try to send swedish chars to or from MsSQL it completely screws it up. The MsSQL is running with Swedish/Finnish charset.

And, No , i can't store them as html-conversion since that made the Java-gurus go up in flames.

Any Ideas where to find the problem would be wonderful.

[jeremy_brooks]

What do you mean 'screws it up'? Is PHP throwing an error, or is it corrupted in the table, or does it get corrupted on extraction? Are you using nchar/nvarchar types?

[asmodean]

PHP won't accept swedish chars at all.
if i send an "åäö" as a login it fails to find the desired user. If i get a simple "Select * from ..." and some of the fields contain swedish chars it shows me the wrong ones.

Somehow i think it gets garbled on extraction

[Anon]

I have the same problem - the only difference is I'm using Czech characters in the database. PHP output itself is OK but data readed from database are incorrect - on the same page. Characters sended to the databse are incorrectly interpretted too.

[Anon]

Same here!
å becomes †
ä becomes „
ö becomes ”

If I use this code in ASP it works:

<%
strConSTR = "driver={SQL Server};server=; uid=; pwd=***; database=dbiom;"

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open strConSTR

SQL = "SELECT colCell1 FROM tblcontent WHERE colID='0'"
set rs = Conn.EXECUTE (SQL)
RESPONSE.WRITE rs(0)

%>

But not this PHP code:
--------------------¨
<?
$connection = mssql_connect ("", "","***") or die ("Fel");
mssql_select_db ("dbiom") or die ("Fel");

$result = mssql_query("SELECT colCell1 FROM tblcontent WHERE colID='0'") or die ("Fel");
$row = mssql_fetch_row($result);

echo $row[0];

?>

Why o why?