dbTalk Databases Forums  

Problem with SQL Anywhere, ASP pages and spanish characters

comp.databases.sybase comp.databases.sybase


Discuss Problem with SQL Anywhere, ASP pages and spanish characters in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mcs04
 
Posts: n/a

Default Problem with SQL Anywhere, ASP pages and spanish characters - 09-14-2004 , 08:16 AM






Let see if someone can help me out.

Last july I downloaded the SQL Anywhere Studio Developer Edition.
I have two databases. One dataBase is SQLA 8 and I created the other
database with the SQL Anywhere Studio Developer 9.
The default collation for the SQLA 8 database is 850ESP.
The default collation for the SQLA 9 database is 1252LATIN1.

I have a webpage (ASP) that performs a query (ODBC) to a SQLA 8 table.
The codification of the ASP page is "iso-8859-1".
I have another webpage (ASP) that performs another query (ODBC) to a
SQLA 9 table. The codification of the ASP page is "iso-8859-1"

The page that performs the query on the SQLA8 table shows the special
spanish characters wrong. It doesn't show (á, é, í, ó, ú, ñ ,etc.)
The page that performs the query on the SQLA9 table shows the special
spanish characters correctly.

If I examine the data through Sysbase Central or the Interactive SQL
I'm able to see the special spanish characters on both Databases.

Could somebody please help me? Could somebody please tell me what can
be the problem? Have other users experienced the same problem with
Spanish Characters? Do I have to download an upgrade? Do SQLA 8 and
ASP pages work alright in Spansih DB? Any information would be greatly
appreciated.

Thank you very much for you attention and help

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.