Home > Backend Development > PHP Tutorial > PHP determines that the input does not exceed the length range of mysql's varchar field_PHP tutorial

PHP determines that the input does not exceed the length range of mysql's varchar field_PHP tutorial

WBOY
Release: 2016-07-21 15:28:11
Original
854 people have browsed it

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?

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/323649.htmlTechArticleBut 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 beyond varch...
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template