Kbase P114574: When creating a table into the PUB schema from a SQL client, the character field has by default the
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/04/2006 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
SYMPTOM(s):
Character field's format is X(8) when the table has been created from a SQL client.
The table has been created in the PUB schema
When dumping the field through Data Administration, this field has also the X(8) default format
The SQL-WIDTH corresponds to the VARCHAR size defined when creating the table
The 4GL format is correct when creating a BINARY field.
CAUSE:
Enhancement request# 20060331-007
FIX:
As a workaround, add the PRO_FORMAT Progress 4GL attribute in the CREATE TABLE query.
The PRO_FORMAT attribute allows to specify the 4GL format for the field.
For example, the query below allows to create a table with a CHARACTER, which has the 4GL format X(25):
create table pub.test (field1 varchar(25) PRO_FORMAT 'X(25)');