SqlDbx Forum

SqlDbx

You are not logged in.

#1 2014-09-03 04:46:34

Alex_N
Member

Column-Length VARCHAR2 incorrect

Hello,
on our Oracle Database the display of the length of Columns with VARCHAR2 Data-Types on Tables are wrong.

When i create a Table like this:

CREATE TABLE WMS.TANDEM_test
    (     column_test VARCHAR2 (10) NOT NULL    )
    TABLESPACE DATA    STORAGE (BUFFER_POOL DEFAULT);

and i look at it or make a select then i get VARCHAR2 (40) displayed.

On this Database it is always a multiplication by 4.

We have different Oracle Databases, in another the multiplication is 3 and in another the display is correct.
When i use SQLPLUS on the Server the display is correct, just as in TOAD.

DB-Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

EDIT:
all SQLDBX-Versions, i use current 4.4 Prof. on Windows 7 Prof.
Sorry for my Bad English :-(

Last edited by Alex_N (2014-09-03 04:50:55)

Offline

#2 2014-09-03 09:01:23

sqldbxhelp
Administrator

Re: Column-Length VARCHAR2 incorrect

Thank you for reporting this issue.
It will be fixed in a next release.

Offline

#3 2014-09-03 17:42:15

Alex_N
Member

Re: Column-Length VARCHAR2 incorrect

sqldbxhelp wrote:

Let me just make sure. You see incorrect length only in Results Grid?
Scripting works correct? Right?

No, the length is always incorrect.
When i make a select the Column-Description in the Data-Grid is false (40).
The definition of the Table-Columns under Tables is wrong.
Also when i use "Script CREATE Table".


The Result of the Script Create:

DROP TABLE WMS.TANDEM_TEST CASCADE CONSTRAINTS;

CREATE TABLE WMS.TANDEM_TEST
    (
      COLUMN_TEST VARCHAR2 (40) NOT NULL
    )
    TABLESPACE DATA
    STORAGE (BUFFER_POOL DEFAULT);


When i execute it and make another Script Create:

DROP TABLE WMS.TANDEM_TEST CASCADE CONSTRAINTS;

CREATE TABLE WMS.TANDEM_TEST
    (
      COLUMN_TEST VARCHAR2 (160) NOT NULL
    )
    TABLESPACE DATA
    STORAGE (BUFFER_POOL DEFAULT);

And so on...

EDIT:
It concerns only Data-Type with VARCHAR2 / CHAR.
Data Type like NUMBER or NCHAR / NVARCHAR2 are correct.

Last edited by Alex_N (2014-09-04 03:04:51)

Offline

Board footer

Powered by FluxBB