Use Unicode datatypes for Oracle database columns populated by user input

Current Situation

• A number of columns in tables of an Oracle database used by JS7 is specified as VARCHAR2 datatype. Such columns require e.g. 2 bytes or more if users add input that is UTF encoded.
• As a result the maximum length of object names added by users is limited to the space required by UTF encoded characters.

Desired Behavior

• Database tables should use a Unicode datatype for strings to allow users to add the max. number of characters for object names including names holding UTF encoded characters.
  • CHAR => NCHAR
  • VARCHAR2 => NVARHAR2
  • CLOB => NCLOB