Dear All,

We use filetoblob & filetoclob function to load data in to blob & clob datatype through sql. Is there a similar function for text datatype too. Please let me know. Thanks in advance.

Best Regards,

Lloyd

Hi Lloyd,
Remember that clob or blob ONLY insert into SBSPACES and not blobspaces.

Gustavo.

Hi Gustavo,

Thanks for your reply, I have created both SBSPACES & BLOBSPACES, the problem i am facing is when i try to insert japanese/chinese data in to blob, clob or text datatype they get stored as junk. But the problem never comes for spanish, french or german data. Can you draw some light on it.

Best Regards,

Lloyd

Hi Lloyd

I do not have much experience with data blobs, but surely the problem this in the form to keep the data and the sets from environment variables.
That it happens with the variables of server LANG, LC_CTYPE,...

Gustavo.