14,953
edits
Number of characters: Difference between revisions
Jump to navigation
Jump to search
+ SQLite
mNo edit summary |
(+ SQLite) |
||
| Line 61: | 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. | ||
== SQLite == | |||
[https://www.sqlitetutorial.net/sqlite-functions/sqlite-length/#targetText=SQLite%20Length,returns%20the%20number%20of%20bytes. Length] function | |||
<PRE> | |||
SELECT LENGTH("狐"); /* return 1 */ | |||
SELECT LENGTH("《王大文 Dawen》"); /* return 11 */ | |||
</PRE> | |||
== Excel == | == Excel == | ||