1 Reply Latest reply: Aug 29, 2012 12:18 PM by Kgronau-Oracle RSS

    How to configure the parameter HS_LANGUAGE and CHARSET

      $ dg4odbc

      Oracle Corporation --- TUESDAY AUG 21 2012 11:17:46.685

      Heterogeneous Agent Release - 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
      xy-20120712-00016728 éå£«ç„±

      the name Column is Garbled.

      who can help me.
        • 1. Re: How to configure the parameter HS_LANGUAGE and CHARSET
          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