Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Unanswered: Sql statement to insert text datatype

    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

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi Lloyd,
    Remember that clob or blob ONLY insert into SBSPACES and not blobspaces.

    Gustavo.

  3. #3
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    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

  4. #4
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •