Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to transfer varchar2 to long raw

Re: How to transfer varchar2 to long raw

From: tamsun <>
Date: Thu, 31 Aug 2006 23:01:02 +0800
Message-ID: <>

On Thu, 31 Aug 2006 06:48:13 -0700, DA Morgan <> wrote:

>tamsun wrote:
>> On Wed, 30 Aug 2006 22:57:20 -0700, DA Morgan <>
>> wrote:
>>> tamsun wrote:
>>>> field F1 is varchar2(4000), I want move the data in F1 into
>>>> another filed F1 which is long raw.
>>>> I wonder how to do by sql?
>>> Why LONG RAW?
>>> What is the business case?
>>> In which version of Oracle?
>> The real field name is YFBZYJ in table T1 and T2.
>> I use Oracle 9i.
>> Some one design the database, the field YFBZYJ is
>> used for client to fill opinion which maybe
>> 100 characters, or maybe 5,000 characters long.
>> So the designer change the origin field type
>> from varchar2(4000) to Long Raw.
>> Yes, Blob or Clob will be better.But web developers use
>> a interface to operate database. This interface can only
>> deal with long raw.
>> I am responsible to dealing with data. Now I should
>> move data to new table with the long raw field.
>Either the web developers are crazy or you have misunderstood
>what they are saying. LONG RAW is binary ... not text. There is
>no way an end user is going to use it to store comments.
>Check out the Data Types page in Morgan's Library at
>to view the various data types and what their definitions.
>In my experience there is no interface that does not allow CLOB
>and you should not accept anything except CLOB without a far better
>understanding of why anyone is claiming it can not be done. That
>said ... what product are they using (include version number).
>It just occured to me that some Oracle products, Forms for example,
>still use LONG to indicate LONG or CLOB. Hopefully this misuse of the
>name will be fixed in Forms 11g.

thank you very much.

Can you give me some suggestions about this scenario:

user will input many characters, maybe 1,000, maybe 10,000. How to store these characters into database except using attachment ? Received on Thu Aug 31 2006 - 10:01:02 CDT

Original text of this message