Oracle Corporation --- TUESDAY AUG 21 2012 11:17:46.685
Heterogeneous Agent Release 18.104.22.168.0 - 64bit Production Built with
Oracle Database Gateway for ODBC
oracle server NLS_CHARACTERSET is UTF8 and mysql server Character set is UTF8, how should i configure the parameters HS_LANGUAGE(initsid.ora) and CHARSET(odbc.ini)? now i
configure the CHARSET = UTF8 and HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P15,but the sql query reslut like this:
SELECT "id","name" FROM "accounts"@LNMYSQL
In general you have to set HS_LANGUAGE=american_america.al32utf8 and charset UTF8. But it also depends if you have set a NLS_LANG value in your environment where you have started your listener. It is also essential to know which utility you are using to query the content. SQL*Plus? If yes, are you using it on Windows or in a Termianl Session and if it is a Terminal session what's the charcter setting of your putty window and the LANG setting of your console?
To avoid Terminal settings and SQL*Plus issues, I would recommend to use the unicode tool SQL*Developer which is using Unicode in its display window by default.It can be downloaded from here: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html?ssSourceSiteId=ocomen