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

Options: ReplyQuote


Subject
Views
Written By
Posted
LENGTH and CHAR_LENGTH give the same length
9020
July 27, 2006 06:18AM


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.