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

Jul 21, 2016 pm 03:28 PM
mysql php utf-8 varchar Down Does not exceed but judgment exist Field of coding scope enter length

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...
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

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian Dec 24, 2024 pm 04:42 PM

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian

CakePHP Date and Time CakePHP Date and Time Sep 10, 2024 pm 05:27 PM

CakePHP Date and Time

CakePHP File upload CakePHP File upload Sep 10, 2024 pm 05:27 PM

CakePHP File upload

CakePHP Routing CakePHP Routing Sep 10, 2024 pm 05:25 PM

CakePHP Routing

CakePHP Project Configuration CakePHP Project Configuration Sep 10, 2024 pm 05:25 PM

CakePHP Project Configuration

Discuss CakePHP Discuss CakePHP Sep 10, 2024 pm 05:28 PM

Discuss CakePHP

How to fix mysql_native_password not loaded errors on MySQL 8.4 How to fix mysql_native_password not loaded errors on MySQL 8.4 Dec 09, 2024 am 11:42 AM

How to fix mysql_native_password not loaded errors on MySQL 8.4

CakePHP Quick Guide CakePHP Quick Guide Sep 10, 2024 pm 05:27 PM

CakePHP Quick Guide

See all articles