On 13-04-2010 01:11:32 +0530, kss ram wrote: > I have a brief query about the data types, according to the documentation > [1]http://monetdb.cwi.nl/SQL/Documentation/Data-Types.html, for storing > string/char type date, we have following options > > 1.CHAR[ACTER] (L) - character string with length L > > 2.VARCHAR (L) | CHARACTER VARYING (L) - string with atmost length L > CLOB | CHARACTER LARGE OBJECT > BLOB | BINARY LARGE OBJECT > DECIMAL(P,S) | NUMERIC(P,S) > > My question is would CLOB would be the right choice to store variable > length/ dynamic string/char data, varchar(L) is out of the picture as i wont > know the length of the string.
yes, in MonetDB, clob is as expensive as char or varchar, so you can use it without any performance impact. ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
