[Monetdb-developers] select data type to store variable length string

Fabian Groffen Fabian.Groffen at cwi.nl
Mon Apr 12 21:46:23 CEST 2010


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.




More information about the developers-list mailing list