#46 ddl wrong with encoding AL32UTF8

closed-fixed
nobody
SQL (23)
5
2011-11-06
2011-10-26
Pierre
No

Hello,
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.

Discussion

  • Pierre
    Pierre
    2011-10-26

    database oracle parameters

     
    Attachments
  • Hi,

    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

    Thanks
    -Alex

     
  • 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

     
    Attachments
  • 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.

     
    • labels: 693843 --> SQL
    • status: open --> closed-fixed
     
  • fixed 1.5 build 23