Project

General

Profile

Bug #4520

Implement proper codepage inheritance from permanent to temp tables

Added by Stanislav Lomany over 4 years ago. Updated over 4 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
01/24/2020
Due date:
% Done:

0%

billable:
No
vendor_id:
GCD
case_num:
version:

Related issues

Related to Database - Feature #3815: more temp-table options Closed

History

#1 Updated by Stanislav Lomany over 4 years ago

#2 Updated by Stanislav Lomany over 4 years ago

A code page can be set for a clob field of a permanent table. E.g.

ADD FIELD "perm-clob" OF "Table" AS clob 
  INITIAL ?
  LABEL "Clob" 
  COLUMN-LABEL "Clob" 
  CLOB-CODEPAGE "UTF-32" 
  ORDER 10

A temp-table can inherit this field using LIKE option at table- or field-level. It should be investigated if a temp-table inherits this codepage or not. A test showed that the answer yes, but at some point it became the opposite, I'm not sure what led to this controversial result.

You can find helpful testcases in the testcases project under uast/column-codepage. At the current level of FWD they do not work "out of the box", see #3815-77

Also available in: Atom PDF