This discussion is archived
2 Replies Latest reply: Dec 23, 2009 7:41 AM by 598001 RSS

Encoding problem in sql developer

598001 Newbie
Currently Being Moderated
I have problems with encoding when use timesten database with DatabaseCharacterSet=AL32UTF8. If I use DatabaseCharacterSet=US7ASCII all ok.
I don't have this problem if connect to timesten using ttisql.
Server - TimesTen Release 11.2.1.4.0 (64 bit Linux/x86_64) (tt1121:53388) 2009-11-19T19:20:36Z
Client - TimesTen Release 11.2.1.4.0 (64 bit Linux/x86_64) (tt1121:53388) 2009-11-19T19:20:36Z on Windows XP
SqlDeveloper - Oracle SQL Developer 2.1.0.63 Build MAIN-63.73
!http://digilo.com/images/work/sqldeveloper_ecncoding.PNG!
  • 1. Re: Encoding problem in sql developer
    jspalmer Journeyer
    Currently Being Moderated
    I can't reproduce this going from SQL Developer on XP with TT 11.2.1.4 32bit installed, to TT 11.2.1.4 32bit on Linux x8664. Can you paste in your DSN settings on the server side and also check the ConnectionCharacterSet setting in the Oracle TimesTen Client DSN Setup (accessed via ODBC Data Source Administrator). Mine is blank. AFAIK SQL Developer should just use AL32UTF8 only as its ConnectionCharacterSet for TT.
  • 2. Re: Encoding problem in sql developer
    598001 Newbie
    Currently Being Moderated
    My problem is related to Client only setup. In this case I can't select AL32UTF8 encoding. Only two encodings available - TIMESTEN8 & US7ASCII. Now I install Client & Server and problem gone.