InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comFri, 05 Sep 2008 19:46:26 GMT20http://www.teradata.com/teradataforum/Topic10412-11-1.aspxI have similar problem with Oracle BI Application. Our teradata developers have created tables with LATIN1 columns and they are loading ASCII chars, that are correct to windows code page. Is it possible to set windows 1250 or ISO8859-2 code page directly in odbc.ini file for ODBC connection? Problem is that ODBC driver should return data not in LATIN1 but in windows 1250 or ISO8859-2 code page. Is it possible? maybe some alter session?Thu, 10 Apr 2008 05:56:51 GMTlucasehttp://www.teradata.com/teradataforum/Topic10412-11-1.aspxCan you post details like ODBC driver version ODBC DSN settings including Session Character Set and AppCodePage Teradata database version Target column Server Character SetDid you try I IANAAppCodePage?On Windows the Applicaton Code Page is set correctly. ODBC Driver Manager will convert ANSI (A) calls to Unicode (W) calls using the Application Code Page.Thu, 31 Jan 2008 13:48:23 GMTShawhttp://www.teradata.com/teradataforum/Topic10412-11-1.aspxThanks for your reply Shaw.OracleBI is a unicode application.I've already tried setting the CharacterSet parameter in the ODBC.ini file but it didn't change the result.At the moment I try to figure out if the problem is in Oracle side or Teradata's side. I tried querying using ADHOC which comes with the ODBC driver but it's broken (I can connect but can't get a result unless it's a numberic value) - Do you know another SQL query client for unix which uses ODBC connectivity?Thu, 31 Jan 2008 07:19:36 GMTshaihttp://www.teradata.com/teradataforum/Topic10412-11-1.aspxIs OracleBI a UNICODE application?If yes: 1- Make sure the Session Character Set is UTF8 or UTF16 (e.g. Connection String should be like UID=X;PWD=Y;CharacterSet=UTF16); 2- Make sure the underlying columns are Unicode (e.g. Create Table Tab1 (Col1 Integer, Col2 VarChar(100) Character Set Unicode).I suggest looking at IANAAppCodePage (see ODBC Driver for Teradata manual) if OracleBI is not a unicode application.Mon, 28 Jan 2008 15:10:01 GMTShawhttp://www.teradata.com/teradataforum/Topic10412-11-1.aspxHello,I'm trying to use OracleBI (OBI) with teradata under AIX 5.2 . I defined everything needed in OBI and also in AIX but when I enter the application and try to query, I get result but where I have Hebrew characters I see meaningless chars (ex: íù àìì).If I execute the same query the application does in windows TD client the characters are displayed as it should.So my question, how do I set the characterset to the ODBC under AIX UNIX system?Sun, 27 Jan 2008 03:52:19 GMTshai