Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!feeder.news-service.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Harry Tuttle Newsgroups: comp.lang.java.programmer Subject: Re: Storing large strings for future equality checks Date: Fri, 10 Jun 2011 10:15:00 +0200 Lines: 10 Message-ID: <95e23mFcv3U1@mid.individual.net> References: <19aedpuwexqkx$.dlg@kimmeringer.de> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net qnPdeeh84aTe41799mFTgwM/C2GMs0rEd+hWyGFPaFWKOHUzw= Cancel-Lock: sha1:zNlSmZDRkGs3o4C4eQh1mEhlUT8= User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 In-Reply-To: <19aedpuwexqkx$.dlg@kimmeringer.de> Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.programmer:5170 Lothar Kimmeringer, 08.06.2011 20:31: > Depends on the database. Some of them force you to use CLOBS for > text-columns with more than 255 characters. CLOBS are a PITA in > terms of indexing. No serious DBMS requires you to use a CLOB for columns with more than 255 characters. The least flexible "big" name is Oracle, which has a limit of 4000 bytes. Beyond that a CLOB is needed. Most others have a much larger limit on VARCHAR columns (32k, 64k, 1GB, ...)