Forum: Building VoltDB Applications

Post: Oracle CLOB equivalent in VoltDB?

Oracle CLOB equivalent in VoltDB?
yairogen
Mar 1, 2011
Hi,
What is the Oracle CLOB equivalent in VoltDB?
I get "DDL Error: "type not found or user lacks privilege: CLOB" in statement starting on lineno: 0" when trying to use CLOB in my DDL.
re: Oracle CLOB equivalent in VoltDB?
tcallaghan
Mar 1, 2011
Yairogen,
We do not support CLOB (Character Large Object) in VoltDB. However, you can create a VARCHAR column up to 1MB in size.
-Tim
Thanks. And the same goes to
yairogen
Mar 1, 2011
Thanks.
And the same goes to BLOB?
Yair
re: BLOBs
tcallaghan
Mar 1, 2011
Thanks.
And the same goes to BLOB?
Yair


Yair,
You'll need to encode your BLOB data and store in VARCHAR. There is an interesting forum thread here http://forum.voltdb.com/showthread.php?488-Blobs&highlight=blobs that discusses BLOBs and VoltDB.
-Tim