Recent project adjustments mainly involve changes to the length of database fields. In DB2, the only way to modify the length of a char field seems to be to delete the table and recreate it. Therefore, the question of which varchar and Char are used
In mysql, the usage of char, varchar, and nvarchar data types is different.
In mysql, the usage of char, varchar, and nvarchar data types is different.
Note:1. char:A fixed length of non-Unicode characters. The maximum length is 8,000 characters.2
An interesting question: the maximum length of varchar in MySQL is bitsCN.com.
An interesting question: the maximum length of varchar in MySQL
The minimum heap of 1 K is obviously maintained, but only nine hundred rows of data are output to
The maximum length of MySQL varchar is always regarded as two bytes to record the length (the length can also be recorded in one byte ), this problem was boring at the time, but some people in the group explained it and suddenly found that it was
I used to think that there are two bytes to record the length (a small length can also be recorded in one byte), so this problem was boring at the time, but someone in the group explained it later, it was suddenly discovered that it was not that
In the MySQL database system, char and varchar are very common, and they are two very similar, are used to save relatively short strings, such as the preservation of the article title, message, email, user name and so on.
The main difference
Description1, Char:Fixed-length non-Unicode character data with a maximum length of 8,000 characters.2, varchar:Variable-length non-Unicode data, up to 8,000 characters long.3, nvarchar:Variable-length Unicode data with a maximum length of 4,000
This is not a fixed number. This article briefly describes the restriction rules.
Strlen calculates string length, one Chinese when 2 characters
Mb_strlen according to its character encoding mode, the statistic character quot
Count the number of
It has always been thought that there are two bytes to record the length (a small length can also be recorded in a byte), so the problem was very boring at that time, but then some people in the group to explain, suddenly found that the original
Oracle| Object | data
The original developer of a new PHP data object (PDO) Data abstraction Layer gives you a brief introduction to the abstraction layer, focusing on running with Oracle.
Need php:5.0Need other: Oracle 8 or later client
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.