Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CLOB inserts being truncated

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
hi all

I'm a student who's picking of Oracle/SQL by myself, so please bear with me. I want to store raw text, and from what I read, I can use the LONG or CLOB datatype, but advisable to use CLOB. Funny thing is, I tried dumping a heap of 'ssss', and Oracle said that it was 'too long', and my insert is truncated to 2,499 characters. I thought CLOB can store up to 4 gb?
 
Status
Not open for further replies.

Similar threads

Junior6202
  • Locked
  • Question
String or binary data would be truncated.
Replies
1
Views
150
fredericofonseca
fredericofonseca
pmaths
  • Locked
  • Question
SQL Transaction Log Files not being deleted.
Replies
2
Views
59
pmaths
pmaths
ShawnMolloy
  • Locked
  • Question
Verify Uniqueness of row inserts
Replies
1
Views
37
mrdenny
mrdenny
rajpree
  • Locked
  • Question
String or binary data would be truncated. Never seen this problem.
Replies
8
Views
92
JamesLean
JamesLean
campdw
  • Locked
  • Question
SQL dynamic meta tags not being displayed
Replies
1
Views
32
r937
r937

Part and Inventory Search

Sponsor

Back
Top