Relationship between character sets and sorting commands in Oracle databases

The following articles mainly introduce the actual commands related to character sets and sorting in Oracle databases. We have specially sorted out the following articles for this purpose. I believe they will be used in future studies. First, we will introduce the main content of the article caused by Java code.

Java code

 
 

  
  
SQL> select * from v$nls_valid_values where parameter='CHARACTERSET' order by 2;  
  
  
PARAMETER VALUE  
  
  
CHARACTERSET AL16UTF16  
  
  
CHARACTERSET AL24UTFFSS  
  
  
CHARACTERSET AL32UTF8  
  
  
SQL> select * from nls_database_parameters;  
  
  
PARAMETER VALUE  
 
 

NLS_LANGUAGE AMERICAN -- legal language name

NLS_TERRITORY AMERICA -- valid region name

 
 

  
  
NLS_CURRENCY $  
  
  
NLS_ISO_CURRENCY AMERICA  
  
  
NLS_NUMERIC_CHARACTERS .,  
 
 

NLS_CHARACTERSET ZHS16GBK -- database Character Set

NLS_CALENDAR GREGORIAN

NLS_DATE_FORMAT DD-MON-RR -- Date Format

 
 

  
  
NLS_DATE_LANGUAGE AMERICAN 
 
 

Oracle Data Character Set and sorting; NLS_SORT BINARY -- sorting method

 
 

  
  
NLS_TIME_FORMAT HH.MI.SSXFF AM  
  
  
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM  
  
  
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR  
  
  
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR  
  
  
NLS_DUAL_CURRENCY $  
 
 

NLS_COMP BINARY -- sorting-related stuff. What is unclear?

 
 

  
  
NLS_LENGTH_SEMANTICS BYTE  
  
  
NLS_NCHAR_CONV_EXCP FALSE  
 
 

NLS_NCHAR_CHARACTERSET AL16UTF16 -- National Character Set

 
 

  
  
NLS_RDBMS_VERSION 10.1.0.2.0 
 
 

You have selected 20 rows.

Used time: 00: 00: 00.03

 
 

  
  
SQL> create table char_t(c1 varchar2(8),c2 nvarchar2(8)); 
 
 

The table has been created.

Oracle Data Character Set and sorting: used time: 00: 00: 00.2

 
 

  
  
SQL> select dbms_metadata.get_ddl('TABLE','CHAR_T') FROM DUAL;  
  
  
DBMS_METADATA.GET_DDL('TABLE','CHAR_T')  
  
  
CREATE TABLE "SCOTT"."CHAR_T"  
  
  
( "C1" VARCHAR2(8),  
  
  
"C2" NVARCHAR2(8)  
  
  
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING  
  
  
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645  
  
  
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)  
  
  
TABLESPACE "USERS"  
 
 

Used time: 00: 00: 05.15

 
 

  
  
SQL> INSERT INTO char_t values('a','a'); 
 
 

One row has been created.

Used time: 00: 00: 00.01

 
 

  
  
SQL> commit; 
 
 

Submitted.

Used time: 00: 00: 00.00

 
 

  
  
SQL> select length(c1),length(c2),lengthb(c1),lengthb(c2) from char_t;  
  
  
LENGTH(C1) LENGTH(C2) LENGTHB(C1) LENGTHB(C2)  
  
  
1 1 1 2  
 
 

Used time: 00: 00: 00.00

 
 

  
  
SQL> insert into char_t values ('medium', 'medium ');
 
 

One row has been created.

Used time: 00: 00: 00.00

The above content describes the Oracle Data Character Set and sorting, hoping to help you in this regard.