#46 ddl wrong with encoding AL32UTF8

SQL (23)

With one of my oracle databases, the ddl of each table is wrong in SQLTools (1.5r22, but the problem already existed in 1.4)
The symptoms : each VARCHAR2 value is multiplicated by 4.

Maybe the encoding parameters are not that ok, but
1) that problem does not occur with the last version of oracle sql developper
2) for some reasons, we can not change them

Thanks in advance for you help. SQL Tools is a great tool.


  • Pierre

    Pierre - 2011-10-26

    database oracle parameters

  • Aleksey Kochetov


    could you provide me with a result pf the query:

    select * from user_tab_columns where table_name = <some table> and column_name = <some varchar2 column>

    That should help me to pin the problem faster


  • Pierre

    Pierre - 2011-10-27

    Hi Alex, thanks for your response.

    I tried with the following request :

    select * from user_tab_columns where table_name = 'TBL' and column_name = 'LIB1' ;

    this query returns an ora-01039 with sqltools, but with Oracle sql developper, I have the result. I attach you this result.

    The lib1 column real format is VARCHAR2(30) , and VARCHAR2(120) is shown in sql tools' ddl.

    Hope that it helps.

  • Pierre

    Pierre - 2011-10-27

    result of the query from user_tab_columns

  • Aleksey Kochetov

    I was able to reproduce this problem in my environment after altering session:

    alter session set nls_length_semantics=char;

    I'll provide a fix in 1-2 days.

    Regarding ora-01039, I hope you just pressed F9 instead of F10 by mistake :). Otherwise it is a new bug and have no clue what can cause that

  • Pierre

    Pierre - 2011-10-27

    Thank you so much, I keep connected to get the fix.

    PS : You are right, I pressed F9, sorry.

  • Aleksey Kochetov

    • labels: 693843 --> SQL
    • status: open --> closed-fixed
  • Aleksey Kochetov

    fixed 1.5 build 23


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks