Home » RDBMS Server » Server Administration » How much characters in varchar2 length 4000?
How much characters in varchar2 length 4000? [message #372525] Tue, 20 February 2001 04:01 Go to next message
Mucky
Messages: 7
Registered: February 2001
Junior Member
Can anyone tell me how much charakters i can put in a varchar2 field with length 4000? How can i calculate this? It seems that the max. number of characters in such a field is 2000. THX

Report message to a moderator

Re: How much characters in varchar2 length 4000? [message #372586 is a reply to message #372525] Mon, 26 February 2001 10:02 Go to previous message
Bobby
Messages: 32
Registered: August 2000
Member
Hi

If ur using Oracle 8 or higher version you can have 4000 characters. It used to be 2000 characters for previous versions.

and to find out how many charcters you have entered.
Select length(col) from tablename;

Report message to a moderator

Previous Topic: Input Truncated to n characters
Next Topic: Constraint trouble
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 08:00:09 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.