Hello,<br><br>Thank you everyone for being supportive!<br><br>I have a brief query about the data types, according to the documentation <a href="http://monetdb.cwi.nl/SQL/Documentation/Data-Types.html">http://monetdb.cwi.nl/SQL/Documentation/Data-Types.html</a>, for storing string/char type date, we have following options <br>
<br><br>1.CHAR[ACTER] (L) - character string with length L<br><br>2.VARCHAR (L) | CHARACTER VARYING (L) - string with atmost length L<br>CLOB | CHARACTER LARGE OBJECT<br>BLOB | BINARY LARGE OBJECT<br>DECIMAL(P,S) | NUMERIC(P,S) <br>
<br>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.<br><br>Thank you for your time and help!<br>
<br><br>