


PHP determines that the input does not exceed the length range of mysql's varchar field_PHP tutorial
Jul 21, 2016 pm 03:28 PM
But if under utf-8 encoding, a Chinese character occupies 3 characters in length, such as the string $str=”Hello!!”;
If you use the strlen function to judge, the length is 11 , just exceeds the length of varchar, but in fact this is not the case. If you directly execute the insert statement in phpmyadmin, this string can be inserted!
For the database, its length is 5, so how do we use PHP to get this length? Use the iconv_strlen() function!
echo iconv_strlen($str,'utf-8′);
Note that the second parameter is the current character set, so the results you get will be based on different character sets. Characters account for one length calculation!
The above statement will output 5. How about it? Can you judge it?

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian

How to fix mysql_native_password not loaded errors on MySQL 8.4
