14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
m
→length of characters
| Line 237: | Line 237: | ||
== Text / String == | == Text / String == | ||
=== | === Length of characters === | ||
<table border=1> | |||
<tr> | |||
<th>Example of string</th> | |||
<th>Length of characters</th> | |||
</tr> | |||
<tr> | |||
<td>fox</td> | |||
<td>3</td> | |||
</tr> | |||
<tr> | |||
<td>The quick brown fox jumps over the lazy dog</td> | |||
<td>43</td> | |||
</tr> | |||
<tr> | |||
<td>狐</td> | |||
<td>1</td> | |||
</tr> | |||
<tr> | |||
<td>敏捷的棕毛狐狸從懶狗身上躍過</td> | |||
<td>14</td> | |||
</tr> | |||
</table> | |||
* PHP: [http://php.net/mb_strlen PHP mb_strlen function] | * PHP: [http://php.net/mb_strlen PHP mb_strlen function] | ||
<pre> | <pre> | ||
echo mb_strlen("《王大文 Dawen》", 'UTF-8'); // return 11 | echo mb_strlen("狐", 'UTF-8') . PHP_EOL; // return 11 | ||
echo strlen("《王大文 Dawen》"); // return 21 | echo strlen("狐") . PHP_EOL; // return 3 | ||
echo mb_strlen("《王大文 Dawen》", 'UTF-8') . PHP_EOL; // return 11 | |||
echo strlen("《王大文 Dawen》") . PHP_EOL; // return 21 | |||
</pre> | </pre> | ||
* 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> | ||
SELECT CHAR_LENGTH("狐"); /* return 1 */ | |||
SELECT LENGTH("狐"); /* return 3 */ | |||
SELECT CHAR_LENGTH("《王大文 Dawen》"); /* return 11 */ | SELECT CHAR_LENGTH("《王大文 Dawen》"); /* return 11 */ | ||
SELECT LENGTH("《王大文 Dawen》"); /* return 21 */ | SELECT LENGTH("《王大文 Dawen》"); /* return 21 */ | ||
</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. | |||
* Excel: [https://support.office.com/en-us/article/LEN-LENB-functions-29236f94-cedc-429d-affd-b5e33d2c67cb?ui=en-US&rs=en-US&ad=US LEN function] / [https://support.office.com/zh-tw/article/LEN%E3%80%81LENB-%E5%87%BD%E6%95%B8-29236f94-cedc-429d-affd-b5e33d2c67cb LEN 函數] | * Excel: [https://support.office.com/en-us/article/LEN-LENB-functions-29236f94-cedc-429d-affd-b5e33d2c67cb?ui=en-US&rs=en-US&ad=US LEN function] / [https://support.office.com/zh-tw/article/LEN%E3%80%81LENB-%E5%87%BD%E6%95%B8-29236f94-cedc-429d-affd-b5e33d2c67cb LEN 函數] | ||
<pre> | <pre> | ||
=LEN("狐") // return 1 | |||
=LEN("《王大文 Dawen》") // return 11 | =LEN("《王大文 Dawen》") // return 11 | ||
</pre> | </pre> | ||