SqlDbx
You are not logged in.
Pages: 1
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
Thank you for reporting this issue.
It will be fixed in a next release.
Offline
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
Pages: 1