For more information about Oracle database storage m & #179; (m3), oracle database storage m3

Source: Internet
Author: User

For more information, see <G id = "1"> </G>.

 

-------------- Note: The following operations are performed in rhel vnc, not in secureCRT. ------------
-------------- Cause: If it is executed in secureCRT, m Lu will be shown as: m Lu. See the following. Why? I haven't studied it yet --

 

The experiment process is as follows:

[oracle@lei1 ~]$ export NLS_LANG=AMERICAN_AMERICA.AL32UTF8[oracle@lei1 ~]$ sqlplus scott/aaaaaaSQL*Plus: Release 11.2.0.3.0 Production on Sat Jun 20 10:02:14 2015Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> desc test_t1; Name        Null?    Type ----------------------------------------- -------- ---------------------------- C1          VARCHAR2(20)SQL> truncate table test_t1;Table truncated.SQL> insert into test_t1 values('m³');1 row created.SQL> commit;Commit complete.SQL> select * from test_t1;C1--------------------m³SQL> select property_value from database_properties where property_name='NLS_CHARACTERSET';PROPERTY_VALUE--------------------------------------------------------------------------------AL32UTF8SQL> 


 


For a description of the mathematical symbols stored in Oracle databases, see the following mos article:

Need to store greek, math symbols (Doc ID 1060862.6)

 

This article is reproduced in the full text below:

Problem Description:  ====================  You would like to store extended Math symbols and the Greek letter Alpha in the database because your business application requires the presence of those symbols. You do not know which character set is on the database, but on the application your NLS_LANG is set to NLS_LANG=American_America.we8iso8859p1 or AMERICAN_AMERICA.WE8MSWIN1252.  Solution Summary:  =================  Your database was created with the wrong character set.  Recreate the database with the correct character set.  Choice of correct character sets:    EL8ISO8859P7    UTF8    Al32UTF8 Solution Description:  =====================  To find which character set is on the database level, connect internal or as DBA and run the following query:      SVRMGR> select * from nls_database_parameters;  You probably do not have EL8ISO8859P7, UTF8 or the AL32UTF8 character set listed for the NLS_CHARACTERSET parameter.  Other character sets do not contain Greek letters or extended Math symbols.  The character set that does is EL8ISO8859P7 or a UNICODE as character set, see:Note:260893.1 Unicode character sets in the Oracle database Solution Explanation:  =====================  All character data in an Oracle database is stored using a single character encoding scheme (character set). The database encoding scheme does not have to be the same as that used by an application to access database data.  Although, the character set on the database level determines the choice of characters that can be stored. The database character encoding scheme is specified when the database is created, before it contains any data, by the CREATE DATABASE statement. The client-side encoding scheme is specified by defining the NLS_LANG parameter for a session. Once CREATE'd, a database encoding scheme cannot be changed without re-creating the database.


 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.