Problem with special characters on web applications

[seeyou]

Hi.

I'm using ASA 8.0 (Demo) to connect my WebApplication (ASP.NET) to a sybase database. All it seems ok, except when I use special characters like 'áãâç...'. That special characters are replaced by another characters making my data unreadable.
The internet browser shows to me wrong characters even with correct data in my database.
The problem are in ASA 8.0, ODBC configuration or in my connection string.
If I use a SQL SERVER database I don't have that problem. --- seeyou ---

 

[JMCraig]

Hi,
In my experience, ASA questions don't get answered very well on this forum. But let me give you a suggestion or two.

You don't give us enough help on what these &quot;special characters&quot; are to know for sure, but is it possible your ODBC data source is set up to do character translation? That's a problem on an application I've worked with in the past, but I'm not sure what ODBC driver you'd be using. On the Sybase 11.x ODBC driver, on the Advanced tab, there's a &quot;Translate&quot; button. Presumably, you'd want the equivalent of <No Translator> on your driver (whatever setting that might be). This could explain why it works with ASE and not with ASA.

Also, try connecting to ASA with another type of client and verify that you see the right byte values for the characters in question. See if you can change the settings in that client to do character translation; that'll let you experiment with the settings that affect such things.

Best of Luck,

John J M Craig
Alpha-G Consulting, LLC

http://alphagconsulting.bizhosting.com

nsjmcraig@netscape.net

 

[seeyou]

Hi again.

Thanks for your try.
I solved my problem with special characters (portuguese characters like àáãâ...) with the connection string parameter CS=&quot;iso15&quot; (CS=CharSet).
Now, all it's perfect. --- seeyou ---