Ramblings

mysql [localhost] {msandbox} ((none)) > select length(crc32(3)) * 8, bit_length(crc32(3));
+----------------------+----------------------+
| length(crc32(3)) * 8 | bit_length(crc32(3)) |
+----------------------+----------------------+
|                   80 |                   80 |
+----------------------+----------------------+
1 row in set (0.00 sec)

6 Responses to “Is BIT_LENGTH() useful?”

1. Robert Wultsch says:

   19/05/2009 at 10:45 am

   I have never seen bit_length outside of man pages.
2. Rob says:

   19/05/2009 at 11:24 am

   Does it change with a UTF-16 string?
3. Antony Curtis says:

   19/05/2009 at 12:58 pm

   Try using it with a UTF8 string which has some multi-byte characters. LENGTH should return number of characters, BIT_LENGTH would include all the bytes which are used to encode it.
   So I would say: Definitely useful.
4. Shlomi Noach says:

   19/05/2009 at 1:52 pm

   @Antony:

   LENGTH() returns the number of bytes consumed, not the number of characters.
   To get the number of characters, you have CHAR_LENGTH().

   With non-ascii characters, and on utf8 charset, it will follow that LENGTH(t) > CHAR_LENGTH(t)

   (BTW, BIT_LENGTH is still LENGTH*8 in this case)
5. Ronald Bradford says:

   19/05/2009 at 11:57 pm

   Have never used it myself, and have never seen it in use.
6. PB says:

   27/05/2009 at 6:03 pm

   I have never seen bit_length outside of man pages.