I have a string with length as 4000 and I am trying to store the same in Oracle DB column with type as VarChar(4000). The issue is that the string in not getting stored properly . This is skipping some of the characters.
Asked
Active
Viewed 226 times
0
-
2Some characters or at end? – CS_noob Dec 14 '18 at 12:15
-
1what is the oracle version you are using – jayendra bhatt Dec 14 '18 at 12:15
-
It's skipping characters the end. – Sammy Dec 14 '18 at 12:15
-
@jayendrabhatt : Oracle version 11g – Sammy Dec 14 '18 at 12:16
-
3Please add more information to your question: table schema, code for saving the string, string to be saved, exact result of operations, Oracle version etc. – Codo Dec 14 '18 at 12:41
1 Answers
0
The string was actually an XML that was pretty printed. I trimmed the newlines and reformatted in notepad so that it was in a single line when word-wrapped. The oracle DB was able to store it.
So, I adjusted the length of string accordingly by keeping an eye on the no of characters. This worked for me!!
Sammy
- 336
- 1
- 12