varchar2(100 char) vs varchar2(100 bytes)
947771Mar 13 2013 — edited Mar 13 2013hi,
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