Oracle character length function and example tutorial
-Oracle uses LENGTHB inside
Sql> Select LENGTHB (' 123456 ') from dual;
LENGTHB (' 123456 ')
-----------------
6
Sql> Select LENGTHB (' 123456 Tianjin ') from dual;
LENGTHB (' 123456 Tianjin ')
---------------------
MySQL Tutorial > select char_length (' 123456 ');
+-----------------------+
| Char_length (' 123456 ') |
+-----------------------+
| 6 |
+-----------------------+
1 row in Set (0.00 sec)
Mysql> Select Char_length (' 123456 Tianjin ');
+---------------------------+
| Char_length (' 123456 Tianjin ') |
+---------------------------+
| 10 |
+---------------------------+
1 row in Set (0.00 sec)
Mysql>
Example Three
Sql> Select LENGTHB (' 123456 ') from dual;
LENGTHB (' 123456 ')
-----------------
6
Sql> Select LENGTHB (' 123456 Tianjin ') from dual;
LENGTHB (' 123456 Tianjin ')
---------------------
10
Sql>