I don't think you can restrict the subtitle to 255 characters. If a subtitle is longer than 255 characters, you have to have some way to store it. Also, if we store a unicode subtitle, you'd be restricting the title to only 127 characters. Newer mysql servers _can_ index blobs. I believe that you can set how many of the first characters of the blob are indexed. If you _have_ to support indexing of subtitles with older mysql servers, then maybe create a new subtitle_index table that contains the first 255 characters (or less) of the entries in the subtitle field. Note that with the MARC DB schema I'm using, if a value is less than 255 characters, it is stored directly in the Subfield_Value table, if it is longer, it is stored in a separate blob table. This means that will be necessary to generate and maintain separate indexes for searching purposes. Steve.