datatype problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: datatype problem

  1. #1
    Join Date
    Nov 1999
    Posts
    226
    Hi

    How to convert CLOB to varchar 2 or char. I am importing a table from 8.1.5 which has a clob datatype in one of teh columns and giving me a problem in export and import .So let me know if there is anything I can do

    Thanks

  2. #2
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174
    I have the same issue. Altough in ine, I have a table that has a CLOB column. My users are using Brio and they need to able to query this table, including this CLOB column.

    However, it turns out, Brio can NOT query CLOB datatypes.

    My first idea was: create a view of the table and convert the CLOB to varchar. I think that's wishful think, though. I don't think you can do any data type conversion in creating a view. Could you?

    Second thougth: just duplicate the table and duplicate it with the column as varchar.

    In either case, how would I convert th CLOB into varchar?

    Thanks.

Posting Permissions

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



Click Here to Expand Forum to Full Width