Re: mssql versus odbc HELP

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
.

Relevant Pages

  • Re: How to change characterset in SQL Enterprise Manager?
    ... Yes, I will alter them to nchar, nvarchar, and ntext. ... where I can set sql server characterset to unicode? ... >If you want to change all you character data to unicode, ... >> I want to change characterset to Unicode in server ...
    (microsoft.public.sqlserver.server)
  • Re: Slightly OT: Size of Oracle vs MS SQL database tables
    ... a mixed Oracle/MS SQL Server 2005 environment. ... Oracle software bid was five times the MS bid). ... all of our data tables more than double in size under MS SQL Server 2005. ... The characterset you mentioned supports UTF-8 and won't modify ...
    (comp.databases.oracle.server)
  • Re: mssql versus odbc HELP
    ... On Aug 31, 3:57 am, Erwin Moller ... When use mssql for db connectivity, and then i call mssql_fetch_array, ... Find out in which characterset MS SQL server is using to store data. ... the database is using latin1 collation. ...
    (comp.lang.php)