indeed the doc is not clear; it seems the limit is 8k, except if you write max... what I know by using oracle dbms, however, is that varchar is limited to 4k; I may be wrong, I have not checked it carefully and I prefer clob/blob for arbitrarely large data