• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1227
  • Last Modified:

Unlimited character text field in Oracle 11g

Is 4000 the max character limit I can use in a content field? Is there no equivalent to the unlimited text field in SQL Server?

If so, how do I define this new unlimited field so I can create my table with it?

Thanks.
0
Starr Duskk
Asked:
Starr Duskk
  • 2
1 Solution
 
cyberkiwiCommented:
Hi there,

You can use a BLOB which is equivalent (sort of) to SQL Server TEXT/BLOB field
http://ss64.com/ora/syntax-datatypes.html
0
 
cyberkiwiCommented:
Sorry, should have pointed you to

oracle == sql server
CLOB == TEXT
BLOB == BLOB (binary)
0
 
slightwv (䄆 Netminder) Commented:
CLOB is correct.  Just wanted to add it will hold 4Gig in a single column.

Not unlimited but close.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now