varchar2 (char)
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
1