Home » SQL & PL/SQL » SQL & PL/SQL » Invalid text is stored which is > 4000 length in nclob field
Invalid text is stored which is > 4000 length in nclob field [message #302706] Tue, 26 February 2008 12:41 Go to next message
techluver
Messages: 16
Registered: May 2006
Junior Member
If I try to persist some text with < 4000 char length, in nclob column then no issues

But I try to persist >4000, invalid chars(like inverted ??) are persisted in DB instead of actual text. I'm using oracle 9i with 10g driver along with spring+jdbc
Please let me know how I can solve this issue.

[Updated on: Tue, 26 February 2008 15:22]

Report message to a moderator

Re: Invalid text is stored which is > 4000 length in nclob field [message #303384 is a reply to message #302706] Fri, 29 February 2008 02:08 Go to previous message
cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA
Senior Member

Hai!

You will use the Varchar2 to create that column.

Try it. :
Previous Topic: Unable to Load the English months in Staging Table.
Next Topic: Help needed for BEFORE DELETE Trigger
Goto Forum:
  


Current Time: Sat Feb 15 23:26:47 CST 2025