21 Jan 2010
By using the import feature of SQL-Assistant, you are able to load clobs or blobs,
SQLA has parameter markers for blobs and clobs:
Insert Into Foo Values ( 'bar', ?B, ?C)
The ?B is a placeholder for blob, and ?C is a placeholder for clob
You must sign in to leave a comment.
Hello,
I have created a new table with a CLOB field intended to store a deliminated character string, however a standard INSERT statement is only loading the first character of said string.
Any thoughts or guidance as to why this is happening and how to fix please?
All input gratefully received.
Thanks,
Lee UK