Our Domino server is installed on Windows server 2003 of traditional Chinese edition and its web output has been configued as UTF-8.I setup an ODBC connection to a SQL server on another Windows server 2003 of traditional Chinese edition.
I have an agent running sql statement from a web form to access the SQL server with some nvarchar fields. If the sql statement contains some characters other than English and traditional Chinese, it can’t be correctly accepted by the ODBCquery.sql property. Because I can print the sql statement with multi-language characters correctly to the console. But after I assigned the sql statement to the ODBCquery.sql and when I msgbox this ODBCquery.sql, there are only English and traditional Chinese characters displayed correctly and other laguage characters are displayed as blank.
Any advise? Thank you in advance.