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 |