|
|
Posted by Mel on 07/11/06 14:01
On 2006-07-11 23:25:45 +1000, eugenio@iatmgu.com said:
> Thanks for the reply....
>
> I've tried utf-8 and ISO 8859-1 but I either get empty squares or
> question marks.
> The html source shows question marks as well. I'm guessing, but I think
> the problem may be that the mssql module is not able to handle the
> chars or something with the apache config. When I run the same script
> on win2k3 server with php and iis6 the characters show without a
> problem.
>
> Jerry Stuckle wrote:
>> eugenio@iatmgu.com wrote:
>>> Hi...not sure if this is the right group for this posting, but i'm
>>> don't know where else to post. I've got a simple problem...I have a
>>> linux box running apache 2.0 and php5. I'm trying to use the mssql
>>> functions in php to retreive data from a mssql server 2k. I'm pulling
>>> data from the customers table in the northwind db and i'm getting
>>> strange characters instead of special characters. Below is a sample
>>> output:
>>>
>>> (where the quotes are i get a question mark)
>>> What I'm getting:
>>>
>>> ALFKI - Alfreds Futterkiste - Maria Anders
>>> ANATR - Ana Trujillo Emparedados y helados - Ana Trujillo
>>> ANTON - Antonio Moreno Taquer?a - Antonio Moreno
>>> AROUT - Around the Horn - Thomas Hardy
>>> BERGS - Berglunds snabbk?p - Christina Berglund
>>>
>>>
>>> What I should get:
>>>
>>> ALFKI - Alfreds Futterkiste - Maria Anders
>>> ANATR - Ana Trujillo Emparedados y helados - Ana Trujillo
>>> ANTON - Antonio Moreno Taquería - Antonio Moreno
>>> AROUT - Around the Horn - Thomas Hardy
>>> BERGS - Berglunds snabbköp - Christina Berglund
>>>
>>
>> What charset are you using for your page? And what does the page source
>> show?
>>
>> Probably alt.html might have been a better group to start, but this one
>> is a logical choice.
>>
>> --
>> ================= Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstucklex@attglobal.net
>> =================
Grasping at straws, but have you checked the collation setting on the
MSSQL server?
Navigation:
[Reply to this message]
|