CODEWITHSUNDEEP
oracle11gvarchar2
name_masked
name_masked

Reputation: 9794

Handling large String values in database VARCHAR2 columns

I have defined an VARCHAR2(2000 CHAR) field in the database. Often, we run into issues where the client input is more than 2000 characters and we end up missing out on the record. I am not sure if setting the field(s) to maximum characters would be the best way to solve this.

What would be the best way to handle such arbitrary large text input ?

Upvotes: 0

Views: 364

Answers (3)

Alex Poole
Alex Poole

Reputation: 191265

If you're confident the client input will never exceed 4000 characters then you can increase the field size to that. Otherwise, you'll need to use a CLOB.

Upvotes: 1

Amadan
Amadan

Reputation: 198324

CLOB. It's slower, can't be a primary key, some other limitations apply; but it can hold up to 4Gb.

Upvotes: 1

Andy
Andy

Reputation: 9048

Use a CLOB (Character Large Object) column. These can store up to 4gb of character data.

Upvotes: 2

Related Questions