Number of characters: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<table border="1" class="wikitable sortable"> <tr> <th>Example of string</th> <th>Number of characters</th> <th>Number of bytes</th> </tr> <tr> <td>fox</td> <td>3</td> <td>3</...") |
mNo edit summary |
||
| Line 18: | Line 18: | ||
<td>狐</td> | <td>狐</td> | ||
<td>1</td> | <td>1</td> | ||
<td> | <td>3</td> | ||
</tr> | |||
<tr> | |||
<td>象</td> | |||
<td>1</td> | |||
<td>3</td> | |||
</tr> | |||
<tr> | |||
<td>🐘</td> | |||
<td>1</td> | |||
<td>4</td> | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
Revision as of 17:46, 5 April 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 |
// number of characters
echo mb_strlen("狐", 'UTF-8') . PHP_EOL; // return 1
echo mb_strlen("《王大文 Dawen》", 'UTF-8') . PHP_EOL; // return 11
// number of bytes
echo strlen("狐") . PHP_EOL; // return 3
echo strlen("《王大文 Dawen》") . PHP_EOL; // return 21
- MySQL: MySQL CHAR_LENGTH() function
// 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 */
- MySQL :: MySQL 8.0 Reference Manual :: 11.4.1 The CHAR and VARCHAR Types e.g. VARCHAR(5) or CHAR(5) means can hold up to 5 characters.
- Excel: LEN, LENB functions / LEN、LENB 函數
// number of characters
=LEN("狐") // return 1
=LEN("《王大文 Dawen》") // return 11
// number of bytes
=LENB("狐") // return 2
=LENB("《王大文 Dawen》") // return 16