Hello all...
The environment is WIN2000/MSSQL/PHP. I'm from Iceland and we have some special characters like 'þ æ ö' and 'á é í ó ú'.
The problem is that when I use php and mssql() to retrieve data from the db these characters return like something else.
I've found many other post regarding this and so I started to use ADO connection and wouldn't you know it everything works like it should be. BUT!!!!
Stupidly enough the software company that did build the database used special Icelandic characters in the table names for some reason and they used spaces as well!!!
So my problem now is how can I access/use these table names in my sql query.
For example:
$rs = $conn->Execute("select * from Fyrirtæki$Söluskrá Tækja");
"Fyrirtæki$Söluskrá Tækja" would be the table name!
This obviously doesn't work! So I tried...
$tblName = "Fyrirtæki$Söluskrá Tækja";
$rs = $conn->Execute("select * from [".$tblName."]");
But that doesn't work either!...
So what can I try next! I have tried to change the character sets for the script back and forth with no luck yet!
Please help!
Best regards, Sigurbjörn Guðjónsson, Iceland
