Difference between revisions of "Number of characters"

From LemonWiki共筆
Jump to navigation Jump to search
m
Line 37: Line 37:
 
</table>
 
</table>
  
 
+
== PHP ==
* PHP: [http://php.net/mb_strlen PHP mb_strlen function]
+
* PHP: [https://www.php.net/manual/en/function.strlen.php strlen] & [http://php.net/mb_strlen PHP mb_strlen function]
 
<pre>
 
<pre>
 
// number of characters
 
// number of characters
Line 44: Line 44:
 
echo mb_strlen("《王大文 Dawen》", 'UTF-8') . PHP_EOL; // return 11
 
echo mb_strlen("《王大文 Dawen》", 'UTF-8') . PHP_EOL; // return 11
  
// number of bytes
+
// string length (number of bytes)
 
echo strlen("狐") . PHP_EOL; // return 3
 
echo strlen("狐") . PHP_EOL; // return 3
 
echo strlen("《王大文 Dawen》") . PHP_EOL; // return 21
 
echo strlen("《王大文 Dawen》") . PHP_EOL; // return 21
 
</pre>
 
</pre>
 +
 +
== MySQL ==
 
* MySQL: [http://www.w3resource.com/mysql/string-functions/mysql-char_length-function.php MySQL CHAR_LENGTH() function]
 
* MySQL: [http://www.w3resource.com/mysql/string-functions/mysql-char_length-function.php MySQL CHAR_LENGTH() function]
 
<PRE>
 
<PRE>
Line 59: Line 61:
 
</PRE>
 
</PRE>
 
* [https://dev.mysql.com/doc/refman/8.0/en/char.html MySQL :: MySQL 8.0 Reference Manual :: 11.4.1 The CHAR and VARCHAR Types] e.g. {{kbd | key=<nowiki>VARCHAR(5)</nowiki>}} or {{kbd | key=<nowiki>CHAR(5)</nowiki>}} means can hold up to 5 characters.
 
* [https://dev.mysql.com/doc/refman/8.0/en/char.html MySQL :: MySQL 8.0 Reference Manual :: 11.4.1 The CHAR and VARCHAR Types] e.g. {{kbd | key=<nowiki>VARCHAR(5)</nowiki>}} or {{kbd | key=<nowiki>CHAR(5)</nowiki>}} means can hold up to 5 characters.
 +
 +
== Excel ==
 
* Excel: [https://support.office.com/en-us/article/len-lenb-functions-29236f94-cedc-429d-affd-b5e33d2c67cb LEN, LENB functions] / [https://support.office.com/zh-tw/article/LEN%E3%80%81LENB-%E5%87%BD%E6%95%B8-29236f94-cedc-429d-affd-b5e33d2c67cb LEN、LENB 函數] {{exclaim}} Result of the function {{kbd | key=LENB}} is not the same with the result in other programming language.
 
* Excel: [https://support.office.com/en-us/article/len-lenb-functions-29236f94-cedc-429d-affd-b5e33d2c67cb LEN, LENB functions] / [https://support.office.com/zh-tw/article/LEN%E3%80%81LENB-%E5%87%BD%E6%95%B8-29236f94-cedc-429d-affd-b5e33d2c67cb LEN、LENB 函數] {{exclaim}} Result of the function {{kbd | key=LENB}} is not the same with the result in other programming language.
 
<pre>
 
<pre>

Revision as of 14:49, 4 June 2019

Example of string Number of characters Number of bytes
fox 3 3
The quick brown fox jumps over the lazy dog 43 43
1 3
1 3
🐘 1 4
敏捷的棕毛狐狸從懶狗身上躍過 14 28

PHP

// number of characters
echo mb_strlen("狐", 'UTF-8') . PHP_EOL; // return 1
echo mb_strlen("《王大文 Dawen》", 'UTF-8') . PHP_EOL; // return 11

// string length (number of bytes)
echo strlen("狐") . PHP_EOL; // return 3
echo strlen("《王大文 Dawen》") . PHP_EOL; // return 21

MySQL

// number of characters
SELECT CHAR_LENGTH("狐"); /* return 1 */
SELECT CHAR_LENGTH("《王大文 Dawen》"); /* return 11 */

// number of bytes
SELECT LENGTH("狐"); /* return 3 */
SELECT LENGTH("《王大文 Dawen》"); /* return 21 */

Excel

// number of characters
=LEN("狐") // return 1
=LEN("《王大文 Dawen》") // return 11

// number of bytes
=LENB("狐") // return 2
=LENB("《王大文 Dawen》") // return 16