| Imagefiles and textfiles into LOBs [message #58320] |
Thu, 14 August 2003 02:18  |
Morten Saethre
Messages: 1
Registered: August 2003
|
Junior Member |
|
|
Which datatypes should I use when handling small image files (.TIF .JPG) and text-files (.TXT) in the same table. Is there a datatype that handles both?
My DBA found that he had to create a table using CLOB for .txt and a BLOB-column for the image-files.
|
|
|
|
| Re: Imagefiles and textfiles into LOBs [message #58322 is a reply to message #58320] |
Thu, 14 August 2003 04:21  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
We use only BLOBs (a DBA decision), we consider text files (.TXT) as binary files too, treatment is on the client side OS... they are handled just like word docs, pdf files, powerpoint presentations... at our shop. It actually never bothered me. Tom Kyte advises to use a BLOB if you don't want some character set conversions to take place.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
