Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
With a UTF-8 database, CODEUNITS32 is not correct with create table script. The values are 4x higher than they should be.
Description
With a UTF-8 database, CODEUNITS32 is not correct with create table script. The values are 4x higher than they should be.
If you create a table for example
CREATE TABLE "TEST "."Table" ( "C1" VARCHAR(16 CODEUNITS32) NOT NULL , "C2" VARCHAR(32 CODEUNITS32) NOT NULL , "C3" CHAR(3 CODEUNITS32) NOT NULL , "C4" TIMESTAMP NOT NULL , "C5" TIMESTAMP , "C6" CHAR(1 CODEUNITS32) , "C7" VARCHAR(200 CODEUNITS32) ) DISTRIBUTE BY HASH("C1") IN "TEST" ORGANIZE BY ROW;
Then, right click on a table -> Generate SQL -> Creation script -> in editor
It then shows:
CREATE TABLE TEST.TABLE ( C1 VARCHAR(64 CODEUNITS32) NOT NULL, C2 VARCHAR(128 CODEUNITS32) NOT NULL, C3 CHARACTER(12 CODEUNITS32) NOT NULL, C4 TIMESTAMP NOT NULL, C5 TIMESTAMP, C6 CHARACTER(4 CODEUNITS32), C7 VARCHAR(800 CODEUNITS32) ) IN TEST DISTRIBUTE BY HASH (C1) ORGANIZE BY ROW;
The value is 4 times bigger then original.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.