Ari Halberstadt

A member of the Philip Greenspun's Homepage community since April 8, 1998

If you were to log in, you'd be able to get more information on your fellow community member.

March 4, 1999, on Oracle 8 RDBMS Server:
Another way to handle long strings is to break them up into segments. Instead of storing the text or a message directly in a message table, you add another table, say msg_text, with columns msg_id, seg_num, and seg_text. On insert the message is split into segments limited to the smaller of the query limit and database varchar limit, minus the overhead of the sql query (the "insert..." stuff). It makes for an ugly insert operation, though. I had to do this to work with PostgreSQL, which has an 8K limit. If you split on a word boundary (a whitespace character) then a full text indexer might be able to make sense of this.