Oracle insert m2 m?-CodePudding

From a Java background to the database to m2, m3, but in the database into m?

Test again, in the pl/SQL insert statement:
The update t set value='https://bbs.csdn.net/topics/m2, m3'
Results were turned into m? , m? ,
The field type is NVARCHAR2, help me take a look at how to do,

CodePudding user response:

Saved as a character of 'm2, and m3 ORACLE to do;
But the m3 can use exp (ln (m) * 3),
Such as 10 to the power of 1.5 can be exp (ln (1.5) * 10);

CodePudding user response:

 
- change the characters 
SQL> Select the dump (' m33 ascii_code) from dual; 
ASCII_CODE 
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 
109,51,51 Typ=96 Len=3: 

SQL>