Convert Long to Long RAW in 10gR2

  • From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 14 Jan 2007 20:09:09 +0530


Of a 10gR2 Database, in a 700 GB Table the LONG Field contains standard
JPEG Image with JFIF Compression.

Running CSSCAN to check Character Set conversion from US7ASCII(default)
to AL32UTF8 shows all rows as "Lossy conversion"

Oracle Corp's reply "If you wan to store JPEG's in a Table then you need
to use LONG RAW instead of LONG or better BLOB & you need to change this
*before* going to UTF8."

NOTE - A Pro*C Application accesses the respective LONG field to display
the Respective JPEG Image.

Qs. What are easier ways to convert the LONG field to a LONG RAW field?
Will conversion need an additional 700 GB Space?

Qs Will conversion to LONG RAW field impact the Image access Functions,
respective Pro*C Code & thus need a  corresponding Change? (Conversion
to BLOB will certainly necessitate a Change in the manner of access i.e.
respective Functions & Pro*C Code, to my understanding)

Thanks indeed

**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions are unlawful. This e-mail may contain viruses. 
Infosys has taken every reasonable precaution to minimize this risk, but is not 
liable for any damage you may sustain as a result of any virus in this e-mail. 
You should carry out your own virus checks before opening the e-mail or 
attachment. Infosys reserves the right to monitor and review the content of all 
messages sent to or from this e-mail address. Messages sent to or from this 
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

Other related posts: