Oracle 11g Database Modified character Set

Oracle 11g Database Modified character Set

Nls_characterset I set the database to ZHS16GBK while developing the required UTF8

According to the development reaction

When inserting a piece of data into a database table, the Chinese is changed to resemble "? (is the inverse question mark) "Garbled,

In order to successfully insert the success, so made this modification;

Querying character Set parameters

You can query the following data dictionary or view to view the set of character sets

Nls_database_parameters, props$, v$nls_parameters

Nls_characterset represents the character set in the query results, Nls_nchar_characterset represents the national character set

To modify a step:

sql> shutdown immediate;

sql> startup Mount;

Sql> alter system enable restricted session;

Sql> alter system set job_queue_processes=0;

sql> ALTER DATABASE open;

Sql> ALTER DATABASE Character set Internal_use Al32utf8 (or UTF8);

sql> shutdown immediate;

Sql> Startup

Sql>alter system disable restricted session;

Check the changes again.

Sql> select * from Nls_database_parameters;

PARAMETER VALUE

------------------------------ --------------------

Nls_language AMERICAN

Nls_territory AMERICA

Nls_currency $

Nls_iso_currency AMERICA

Nls_numeric_characters .,

Nls_characterset Al32utf8

Nls_calendar Gregorian

Nls_date_format DD-MON-RR

Nls_date_language AMERICAN

Nls_sort BINARY

Nls_time_format HH.MI. Ssxff AM

PARAMETER VALUE

------------------------------ --------------------

Nls_timestamp_format dd-mon-rr hh.mi. Ssxf

F AM

Nls_time_tz_format HH.MI. Ssxff AM TZR

Nls_timestamp_tz_format DD-MON-RR HH.MI. Ssxf

F AM TZR

Nls_dual_currency $

Nls_comp BINARY

Nls_length_semantics BYTE

NLS_NCHAR_CONV_EXCP FALSE

PARAMETER VALUE

------------------------------ --------------------

Nls_nchar_characterset Al16utf16

Nls_rdbms_version 11.2.0.4.0

Rows selected.

Sql> Select Userenv (' language ') from dual;

USERENV (' LANGUAGE ')

----------------------------------------------------

American_america. Al32utf8

This article is from the "Dream Girl" blog, please be sure to keep this source http://dreamgirl1314.blog.51cto.com/1159474/1649512

Oracle 11g Database Modified character Set