Skip to Main Content

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!

varchar2(100 char) vs varchar2(100 bytes)

947771Mar 13 2013 — edited Mar 13 2013
hi,

i am using oracle 11g express r2

while making tables i show, one can make columns like varchar2(100 char) or varchar2(100 bytes)

i chose varchar2(100 CHAR) because i wanted to store only 100 characters.

but in stored proc , when i declare any variable to hold value of above column, i declare varchar2(100).

is it good,

please tel me which approach i should follow in above case.

yours sincerely

Edited by: 944768 on Mar 13, 2013 3:23 AM

Edited by: 944768 on Mar 13, 2013 5:10 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 10 2013
Added on Mar 13 2013
5 comments
50,487 views