On 12/7/07, Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > On Fri, Dec 07, 2007 at 05:43:49PM -0600, P Kishor wrote: > > > I believe it used to... fixed width (CHAR) was quicker than VARCHAR > > while the latter was more space efficient, obviously. > > But he didn't compare variable, but limited width (VARCHAR()) - with variable > unlimited width fields (TEXT)? > --
don't know about other db, but with the ones I have worked, there is no such thing as unlimited text width field. Oracle maxes out VARCHAR at 4000 or 8000 (for NVARCHAR).. I guess you could muck around with CLOBs, but as far as I remember, they are a royal pain in the behind. Don't remember about SQL Server. Never worked with DB2. If it matters, Access maxes out at 64k for its memo fields. Puneet. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
