Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to change default behaviour of varchar2 from BYTE to CHAR ???

795356May 25 2011 — edited May 25 2011
Hii All,
Currently when we create a table with varchar2 column its taking size in bytes. But today we are getting Latin characters where some characters occupy 3 bytes for each character.

So,we have planned to change all our varchar2(20 bytes) to varchar2(20 char) manualy.Please suggest some alternative. Is there any setting at DB level or session level so that whenever we create a table with varchar2 column by default it takes char instead of bytes???


Pls help me.

Regards
RGH
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2011
Added on May 25 2011
9 comments
4,958 views