14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
→Length of characters
| Line 237: | Line 237: | ||
== Text / String == | == Text / String == | ||
=== | === Number of characters === | ||
| Line 243: | Line 243: | ||
<tr> | <tr> | ||
<th>Example of string</th> | <th>Example of string</th> | ||
<th> | <th>Number of characters</th> | ||
<th>Number of bytes </th> | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>fox</td> | <td>fox</td> | ||
<td>3</td> | |||
<td>3</td> | <td>3</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>The quick brown fox jumps over the lazy dog</td> | <td>The quick brown fox jumps over the lazy dog</td> | ||
<td>43</td> | |||
<td>43</td> | <td>43</td> | ||
</tr> | </tr> | ||
| Line 256: | Line 259: | ||
<td>狐</td> | <td>狐</td> | ||
<td>1</td> | <td>1</td> | ||
<td>2</td> | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>敏捷的棕毛狐狸從懶狗身上躍過</td> | <td>敏捷的棕毛狐狸從懶狗身上躍過</td> | ||
<td>14</td> | <td>14</td> | ||
<td>28</td> | |||
</tr> | </tr> | ||
</table> | </table> | ||
| Line 279: | Line 284: | ||
</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: [https://support.office.com/en-us/article/ | * 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 函數] | ||
<pre> | <pre> | ||
=LEN("狐") // return 1 | =LEN("狐") // return 1 | ||
=LEN("《王大文 Dawen》") // return 11 | =LEN("《王大文 Dawen》") // return 11 | ||
=LENB("狐") // return 2 | |||
=LENB("《王大文 Dawen》") // return 16 | |||
</pre> | </pre> | ||
* [http://string-functions.com/length.aspx Calculate String Length Online] | * [http://string-functions.com/length.aspx Calculate String Length Online] | ||
* [https://stackoverflow.com/questions/5290182/how-many-bytes-does-one-unicode-character-take string - How many bytes does one Unicode character take? - Stack Overflow] | |||
=== text match === | === text match === | ||