About storage of m³ (cubic meters) in Oracle database

--------------Note: The following operations are performed in Rhel VNC, not in SECURECRT. ------------
--------------reason: If executed in SecureCRT, M3 will be shown as: M Lu, see below, what is the reason I have not studied--

The following is the process of the experiment:

[[email protected] ~]$ export Nls_lang=american_america. Al32utf8[[email protected] ~]$ sqlplus scott/aaaaaasql*plus:release 11.2.0.3.0 Production on Sat June 20 10:02:14 201  5Copyright (c) 1982, 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 sql> trunc Ate 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 the Oracle database, see the MOS article below:

Need to STORE GREEK, MATH SYMBOLS (Doc ID 1060862.6)

The article is reproduced in full text below:

Problem Description: ==================== you would-to-store extended Math symbols and the Greek letter Alpha in th e database because your business application requires the presence of those symbols. You don't know which character set is on the database and on the application your Nls_lang are set to Nls_lang=american_a Merica.we8iso8859p1 or American_america.  we8mswin1252.  Solution Summary: ================= Your database is 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 Fin D which character set is on the database level, connect internal or as DBA and run the following query:svrmgr> SE  Lect * from Nls_database_parameters;  You probably don't have el8iso8859p7, UTF8 or the Al32utf8 character set listed for the Nls_characterset parameter. Other character sets does not contain Greek letters or extended Math Symbols.  The character set, 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 on an Oracle database is stored using a Single character encoding scheme (character set).  The database encoding scheme does not has to be the same as, the used by a application to access database data. Although, the character set on the database level determines the choice of characters the can is stored. The database character encoding scheme was specified when the database was created, before it contains any data, by the CREA TE 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.

About storage of m³ (cubic meters) in Oracle database