Oracle character column sizes from {PRECISION}

I have a table defined as follows: SQL> desc sb1 Name Null?Type - C1 VARCHAR2(30 CHAR) C2 VARCHAR2(30) Note the difference is the

Re: Oracle character column sizes from {PRECISION}

> On Sep 8, 2015, at 3:42 PM, Steve Baldwin wrote: > > I have a table defined as follows: > > SQL> desc sb1 > Name Null?Type > - > C1

Re: Oracle character column sizes from {PRECISION}

That's true however our DB character set is utf8 and the client charset is AL32UTF8. I was trying to come up with a better performing mechanism than retrieving the information from user_tab_columns. The max length (along with column name and data type) ends up being sent to a client in a json