OraFAQ Forum: SQL & PL/SQL » Varchar2(4000 bytes) to Varchar2(4000 char) Conversion

Home » SQL & PL/SQL » SQL & PL/SQL » Varchar2(4000 bytes) to Varchar2(4000 char) Conversion (Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Varchar2(4000 bytes) to Varchar2(4000 char) Conversion [message #628420]

Tue, 25 November 2014 03:05

queeny
Messages: 20
Registered: July 2011
Location: india

Junior Member

Hi,
I have changed my column size from varchar2(4000 bytes) to varchar2(4000 char).
Can I insert a string with a 4000 characters(more than 4000 bytes) in this column?
If not, are there any best solutions available?

Report message to a moderator

Re: Varchar2(4000 bytes) to Varchar2(4000 char) Conversion [message #628423 is a reply to message #628420]

Tue, 25 November 2014 03:18

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Convert it to CLOB?

Report message to a moderator

Re: Varchar2(4000 bytes) to Varchar2(4000 char) Conversion [message #628424 is a reply to message #628423]

Tue, 25 November 2014 03:21

queeny
Messages: 20
Registered: July 2011
Location: india

Junior Member

Yeah. We can convert that to CLOB but we can not directly alter the table right?
We need to add another column and then only we can convert this to CLOB.
But apart from this checking if there is any other solution.

Report message to a moderator

Re: Varchar2(4000 bytes) to Varchar2(4000 char) Conversion [message #628430 is a reply to message #628420]

Tue, 25 November 2014 04:07

Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Can I insert a string with a 4000 characters(more than 4000 bytes) in this column?

No, 4000 bytes is the maximum size, so it can be 2000 or less characters, depending on your character set.

[Updated on: Wed, 21 June 2017 08:19]

Report message to a moderator

Previous Topic:	index
Next Topic:	Quering Access DB.Table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 12:13:58 CDT 2024