mysql中的设置varchar长度问题_MySQL
如果某一项中设置的是varchar(50)那么对英文当然是50那么对中文呢utf-8的中文占3个字节那么,这个varchar(50)是不是只能存16个汉字了?mysql varchar(50) 不管中文 还是英文 都是存50个的
MySQL5的文档，其中对varchar字段类型这样描述：varchar(m) 变长字符串。M 表示最大列长度。M的范围是0到65,535。(VARCHAR的最大实际长度由最长的行的大小和使用的字符集确定，最大有效长度是65,532字节）。为何会这般变换？真是感觉MySQL的手册做的太不友好了，因为你要仔细的继续往下读才会发现这段描述：MySQL 5.1遵从标准SQL规范，并且不删除VARCHAR值的尾部空格。VARCHAR保存时用一个字节或两个字节长的前缀+数据。如果VARCHAR列声明的长度大于255，长度前缀是两个字节。好了，貌似懂了一点。但具体他说的长度大于255时使用2个字节长度前缀，小学减法题：65535 - 2 = 65533啊。不知道这些大牛如何计算的，暂且保留疑问吧？注：我测试了一下使用UTF8编码，varchar的最大长度为21854字节。在mysql 5.0.45版本，数据库编码utf8下进行测试：varchar最长定义为21785。也就是说不论字母、数字、汉字，只能放21785个。推想：varchar字节最大65535，utf8编码一个字符3个字节65535/3=21785。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
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
The internal code of a Chinese character requires several bytes to store
Dec 14, 2020 pm 05:45 PM
The internal code of a Chinese character requires 2 bytes to store. In the popular Chinese character system in China, the internal code of a Chinese character occupies 2 bytes. Because the Chinese character processing system must ensure compatibility between Chinese and Western languages, ambiguity will occur when ASCII codes and Chinese character national standard codes exist in the system. ; To this end, the Chinese character internal code should be appropriately processed and transformed into the national standard code.
In-depth understanding of the principle of converting Chinese characters to UTF-8 encoding in PHP
Mar 28, 2024 pm 02:44 PM
The principle of converting Chinese characters to UTF-8 encoding actually involves the concept of character encoding. In computers, text characters need to be represented and stored in the form of numbers, and different character encoding schemes specify the correspondence between different characters and numbers. UTF-8 is a commonly used character encoding method. It supports characters worldwide and uses a variable-length encoding method, which can effectively represent characters in various languages and is especially suitable for the Unicode character set. As a common server-side scripting language, PHP also provides
Master the skills of PHP processing Chinese character transcoding
Mar 28, 2024 pm 03:47 PM
PHP is a widely used server-side scripting language commonly used for website development. During website development, we often encounter the need to transcode Chinese characters, especially when dealing with Chinese characters. Mastering the skills of PHP in processing Chinese character transcoding can effectively avoid problems such as garbled characters and improve the stability and user experience of the website. 1.utf8_encode and utf8_decode functions In PHP, you can use the utf8_encode and utf8_decode functions to encode and decode Chinese characters.
Solution to Chinese character input problem in win11
Jan 05, 2024 am 08:29 AM
After we install the win11 system, we must first install the win11 Chinese input method to type Chinese characters. If after installing the Chinese input method, we still cannot type Chinese characters, then the related service may be disabled. Just restart it. The following is Get up and take a look. What to do if win11 cannot type Chinese characters: 1. First, we must make sure that we have downloaded and installed the Chinese input method or third-party input method software. 2. If you don’t know how to add an input method, you can check out the tutorials on this site. 3. If you still cannot type Chinese characters after adding the input method, you need to enable related services. 4. First, right-click the start menu and find "Computer Management" 5. Then enter "Task Scheduler" - "Task Scheduler"
In what form are Chinese characters output on the computer?
Dec 07, 2020 am 11:15 AM
Chinese characters are output in the computer in the form of glyph codes, which are a type of dot matrix code. In order to output Chinese characters on a monitor or printer, the Chinese characters are designed into a dot matrix according to graphic symbols, and the corresponding dot matrix is obtained. code.
What is used to store Chinese characters in computers?
Dec 07, 2020 am 10:17 AM
Chinese characters in computers are stored using internal codes. Chinese internal codes refer to codes composed of 0 and 1 symbols used in computer internal storage, processing, and transmission of Chinese characters. Internal codes are the most basic encoding of Chinese characters, no matter what Chinese characters they are. System and Chinese character input method, the input Chinese character external code must be converted into internal code inside the machine before it can be stored and processed in various ways.
PHP Regular Expression Guide: How to Match Chinese Characters
Mar 20, 2024 pm 05:27 PM
PHP Regular Expression Guide: Methods of Matching Chinese Characters Regular expressions play a very important role in text processing. It can help us quickly and accurately match text content in specific patterns. For the processing of Chinese text, especially the special need of matching Chinese characters, regular expressions can also come in handy. This article will introduce how to use regular expressions to match Chinese characters in PHP and provide specific code examples. First, we need to clarify the scope of Chinese characters in Unicode encoding. The Unicode encoding range of Chinese characters is large
Tips to avoid PHP outputting garbled Chinese characters
Mar 16, 2024 am 10:21 AM
Tips to avoid PHP outputting garbled Chinese characters When programming PHP, you often encounter the situation of outputting Chinese content. However, if you accidentally handle it improperly, it is easy for Chinese characters to be garbled and affect the user experience. Therefore, mastering some skills can effectively prevent PHP from outputting garbled Chinese characters. Some specific code examples will be introduced below to help developers better handle Chinese character output. 1. Set the character encoding to UTF-8 to ensure that the encoding of the PHP file itself is UTF-8. You can add the following comment at the beginning of the code to specify
