Reported By: Elevate Software Reported On: 8/31/2000 For: Version 2.03 Build 1
# 618SQL CREATE TABLE Statement Creating Fields With Incorrect Lengths Sometimes The SQL CREATE TABLE statement is creating string fields with incorrect lengths. The following SQL statement will create the last field as CHAR(12), not CHAR(13).
CREATE TABLE "bancos2.DAT" (
"BANCO_KEY" FLOAT NOT NULL,
"CODIGO_BANCO" CHARACTER(30) NOT NULL,
"NOME_BANCO" CHARACTER(50),
"NUMERO_BANCO" CHARACTER(5),
NOCASE PRIMARY KEY ("BANCO_KEY") COMPRESS FULL
LANGUAGE "Portuguese (Brazilian)" SORT "Default Order"
ENCRYPTED WITH "xywz"
USER MAJOR VERSION 2
USER MINOR VERSION 5);
ResolutionFixed Problem on 8/31/2000 in version 2.04 build 1