Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: BYTE OR CHAR LENGTH Semantics

Re: BYTE OR CHAR LENGTH Semantics

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Mon, 21 May 2007 15:47:07 +0300
Message-ID: <6e49b6d00705210547s33ab0191t1142fee9cafdd120@mail.gmail.com>


It is everything in the docs:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2094.htm#I1020277 ALL_TAB_COLUMNS CHAR_USED VARCHAR2(1)
 B | C. B indicates that the column uses BYTE length semantics. C indicates that the column uses CHAR length semantics. NULL indicates the datatype is not any of the following: CHAR
VARCHAR2
NCHAR
NVARCHAR2 SQL> create table t2 (nameb varchar2(1 byte), namec varchar2(1 char));

Table created.

SQL> desc t2

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 NAMEB                                              VARCHAR2(1)
 NAMEC                                              VARCHAR2(1 CHAR)

SQL> select COLUMN_NAME, CHAR_USED from user_tab_columns   2 where table_name = 'T2';

COLUMN_NAME                    C
------------------------------ -
NAMEB                          B
NAMEC                          C

Gints Plivna
http://www.gplivna.eu

2007/5/21, DBA Deepak <oracle.tutorials_at_gmail.com>:
> Hi Gurus,
>
> How to know whether a table column has been create using BYTE or CHAR length
> semantics?
>
>
> --
> Regards,
>
> Deepak
> Oracle DBA

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 21 2007 - 07:47:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US