What Datatype Can Be Used to Store 10,000 Characters For a Metadata Field? (Doc ID 761377.1)
Last updated on JUNE 02, 2017
Oracle Universal Content Management - Version: 7.5.2 to 10.1.3.3.3 - Release: Stellent to 10gR3 Information in this document applies to any platform.
You have an Oracle database with unicode encoding. All text fields are of the datatype NVARCHAR2. You want to add a new field to the system and define it as a memo type but with a size of 10,000 instead of 1024. You can update the admin server configuration to have MemoFieldSize=10000, however you cannot change the field definition in the database since the NVARCHAR2 type does not expand past 2000 characters. What datatype can you use?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a Million Knowledge Articles and hundreds of Community platforms