Datatype [message #372256] |
Mon, 22 January 2001 23:44 |
Raj
Messages: 411 Registered: November 1998
|
Senior Member |
|
|
How can I store character data which is more than 2000 bytes in a column, (Is there any data type other than varchar & varchar2 Which has a limitation of 2000 bytes)
I appreciate your help.
Regards
Raj
|
|
|
Re: Datatype [message #372260 is a reply to message #372256] |
Tue, 23 January 2001 06:09 |
John R
Messages: 156 Registered: March 2000
|
Senior Member |
|
|
Datatype LONG is probably what you're looking for.
It's not perfect though - you can only have one LONG per table, you cannot include them in WHERE, ORDER BY, GROUP BY clauses, you cannot use them in any function which takes a varchar as an argument (like substr, instr ect)
All in all they're pretty naff.
|
|
|
Re: Datatype [message #372268 is a reply to message #372260] |
Tue, 23 January 2001 21:19 |
Sajit Nair
Messages: 6 Registered: January 2001
|
Junior Member |
|
|
If I have to view the text or export the contents of this field with datatype LONG to an ASCII file...How do I go about it?
Pls. help. I am facing problem in exporting such tables since long.
thanks
|
|
|