Kbase P59154: Why after running Pro-to-ORA are there some columns in ORACLE that have U## in front of the column n
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
Why after running Pro-to-ORA are there some columns in ORACLE that have U## in front of the column name?
GOAL:
Why do some fields in ORACLE have U## in front of the column name and some don't?
FACT(s) (Environment):
Oracle
Oracle DataServer
FIX:
To support case insensitive indexing, Oracle DataServer will create an additional column in Oracle named U##fieldname for all character fields that are part of an index. The new column accommodates the uppercase version of the index.
The reason this is done is because Progress supports case sensitive or case insensitive information, however Oracle only supports case sensitive information. So when a character field in Progress is not case sensitive (case insensitive), Pro-to-ORA will create the a second column U##fieldname, which will handle data and index information.