Kbase 33882: Can fields starting with U##, U##column-name, be removed within Oracle?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Solution ID: P3882
GOAL:
Can fields starting with U##, U##column-name, be removed within Oracle?
FIX:
Since ORACLE is case-sensitive by default, the the DataServer Product (case insensitive by default) allows the user to set the attributes of a field so that it can recognize either case sensitivity or case insensitivity.
When a field is not case sensitive, Progress does not distinguish between uppercase and lowercase letters for that index when sorting or matching data. This feature makes data entry more flexible and easier for end users, since lowercase or uppercase versions of an index can be used. However, when there is a need to enforce an uppercase/lowercase distinction within the application, set the attribute to case sensitive.
Remove the columns whose names start with U##, thus making the fields case sensitive. After doing this, update the schema holder to use case-sensitive indexes.