Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Convert Long to Long RAW in 10gR2
Folks
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
![]() |
![]() |