Skip to Content
author's profile photo Former Member
Former Member

Java Dictionary and Text


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.


Dustin Gronso

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Jul 27, 2004 at 07:56 AM

    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,


    Add comment
    10|10000 characters needed characters exceeded