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.
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
Many thanks for that, I will investigate.