Mario Oberrauch wrote: > Hi, > > as far as i know the maximum row-size is limited to 8k. > Now we have a case that there can be a lot more of data than this (in > plain text - no binary data). I think we will not get a single field > that is larger than that. We could use Long's but LIKE-querys > are in use > so they fall apart. > > Our methods of resolution upto now: > - make bolb's > - save all texts in seperate table and assign foreign key > > Is there a better way to solute? If not, which one of the two named is > to be prefered? (mine is defenitly number two)
Number 2 sounds ok. But may I ask if you can assure that rows filled with data will no exceed 8KB although the row definition will exceed? (This may happen if you have some header data and then january_data char (2000), february_data char (2000), ... december_data char (2000) and you are sure that only one <month>-data-column will be filled with data in existing rows.) Then one can use the SQLMODE ORACLE in which only the length of really existing data is checked and the table definition may exceed this maximum length o 8KB. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
