Java Dictionary and Text

[Former Member]

Hello,

I'm creating an application that requires me to store a large amount of text (around 5000 characters). The first part of the dilema is how I should persist the data in the java dictionary. Should I just create one large field? Or do I need to do something complex and split up each text into smaller lines and have some retrieval method? The next part of the question has to do with searching this text. What is the best way to make this text searchable? Any ideas are much appreciated.

Thanks,

Dustin Gronso

[Opgenorth]

Hi Dustin,

if you want to have the text searchable, you have to split it up. For columns of type 'string' there are two possibilities in the Data Dictonary:

1. varchar: the length is limited to 1000 characters, but you can search with a WHERE condition

2. CLOB allows longer length, but no index or WHERE condition for this column is possible.

Hope this helps,

Juergen