LENGTH and CHAR_LENGTH give the same length
Posted by:
Luca
Date: July 27, 2006 06:18AM
Hi All
I was just testing both function and tried to generate different results for both.
Here is what I did:
mysql> select length(CONVERT('hallo' USING sjis) ) length, char_length(CONVERT('hallo' USING sjis)) char_length ;
+--------+-------------+
| length | char_length |
+--------+-------------+
| 5 | 5 |
+--------+-------------+
1 row in set (0.01 sec)
because LENGHT should give the length in bytes why are both results the same ?
Thnx
LuCa
Subject
Views
Written By
Posted
LENGTH and CHAR_LENGTH give the same length
9020
July 27, 2006 06:18AM
1997
July 27, 2006 12:32PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.