Home » SQL & PL/SQL » SQL & PL/SQL » Field length..
Field length.. [message #226838] Mon, 26 March 2007 14:10 Go to next message
Messages: 57
Registered: March 2006
We have a file that our sales team would like to be loaded into a table. Some the data is between 4000 and 33000 characters in length. They also would like the data to be searchable etc. I brought this up to the dbas as I am not too familiar with the long and clob data types. They said that the data would not be searchable etc in this format.

Has anyone else had to deal with data of this length, and if so what did you do?
Re: Field length.. [message #226845 is a reply to message #226838] Mon, 26 March 2007 14:36 Go to previous messageGo to next message
Michel Cadot
Messages: 65084
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Use CLOB they are made for data of this size and they are "searchable" (depending of what you want to search).


Re: Field length.. [message #226867 is a reply to message #226838] Mon, 26 March 2007 16:06 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
What type of file is being loaded? If it's not a plain text file (ie. if they are .doc, .pdf, .ppt, etc), you'll want to consider a BLOB datatype.
Previous Topic: Need help on primary key
Next Topic: Semantics
Goto Forum:

Current Time: Fri Jul 21 21:50:47 CDT 2017

Total time taken to generate the page: 0.17873 seconds