Posted by Erwin Moller on 08/31/07 07:57

Fad¥ wrote:
> Hello mates,
>
> Something weird is happening or it's just the fact that I'm doing
> something wrong.
> When use mssql for db connectivity, and then i call mssql_fetch_array,
> the values i get from the database will be retrieved with the special
> charactes like "é" transformed to ",".
> In the case of odbc that won't happen?!
>
> Any Idea?
>
> Thanks a lot!
>

Hi,

This MUST have to do with charactersets.
I am not an expert on this, but what you need to find out is this:
1) Find out in which characterset MS SQL server is using to store data.
(eg: latin1, UTF8, etc)
You should be able to find this in via your management thingy in MS SQL
Server.

2) Make sure your output uses the same characterset.

Problem is: a certain bytevalue (or possibly multiple bytes in case of
unicode) is just a value. What character it represents depend on the
characterset you use.

Things might be more complicated, but I would start there with your
research.
Hope this helps you going.
Check in here again to see if somebody with better knowledge of
characterencoding than me has some hints. :-)

Good luck

Regards,
Erwin Moller

[Back to original message]