Database Administration (MOSC)

MOSC Banner

varchar2 (char)

edited Jul 10, 2013 9:05AM in Database Administration (MOSC) 9 commentsAnswered
 Hello 
In one of my apps using oracle v.11.2.0.3 the application is trying to insert some special symbols that are multi-bytes and that leads to errors because the length of the inserted string exceeds the max lenght of the varchar2 string.  We are considering changing these columns from varchar2(100)  to varchar2 (100 char). This way 100 (of whatever the limit is) will always fit into the column regardless of the number of bytes.

It looks like an easy change to make (alter table modify), but are there any known issues with this format? Did any one experience any issues? I'm trying to figure out what is the downside here before we go live. So if anyone is aware of any problems with this please let me know

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center