blocks|key|602324|text|VARCHAR是可变长度的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|602325|CHAR是固定长度。|602326|如果您的内容是固定大小的，那么使用CHAR会获得更好的性能。|602327|有关详细说明，请参阅CHAR+and+VARCHAR+Types上的MySQL页面(请务必阅读评论)。|602328|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.7/en/char.html^0|0|7|0|0|4|0|H|4|0|A|M|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|12|8|@]|D|@$9|13|A|14|1|15]]|E|$]]|$1|L|3|-4|5|6|7|16|8|@]|D|@]|E|$]]]|M|$N|$5|O|P|Q|E|$R|S]]]]

<code>VARCHAR</code> is variable-length.

<code>CHAR</code> is fixed length.

If your content is a fixed size, you'll get better performance with <code>CHAR</code>.

See the MySQL page on <a href="http://dev.mysql.com/doc/refman/5.7/en/char.html" rel="noreferrer">CHAR and VARCHAR Types</a> for a detailed explanation (be sure to also read the comments).

blocks|key|1903068|text|字符|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1903069|用于存储固定length.|1903070|The最大编号的字符串值的|unordered-list-item|1903071|。与VARCHAR.|ordered-list-item|1903072|Uses+characters.|1903073|It's+static+memory+allocation.|1903074|相比，数据类型可以容纳的字符数为255+快50%25|offset|length|style|BOLD|1903075|1903076|VARCHAR|1903077|1903078|用于存储variable+length字母数字数据。|1903079|此数据类型最多可容纳MySQL+5.0.3之前版本的|1903080|：255+MySQL+5.0.3：65,535个字符共享给row.|1903081|1903082|1903083|​|1903084|1903085|It's+‘s+CHAR.|1903086|使用动态内存CHAR|1903087|1903088|entityMap^0|0|0|0|0|0|0|G|8|0|0|0|7|0|0|0|Q|0|0|Q|1|0|X|1|0|0|0|1|0|0|0|D|0|0|A|0|0^^$0|@$1|2|3|4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1G|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1H|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|1I|8|@]|9|@]|A|$]]|$1|J|3|K|5|I|7|1J|8|@]|9|@]|A|$]]|$1|L|3|M|5|I|7|1K|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1L|8|@$P|1M|Q|1N|R|S]]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1P|8|@$P|1Q|Q|1R|R|S]]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]|$1|X|3|Y|5|I|7|1T|8|@$P|1U|Q|1V|R|S]]|9|@]|A|$]]|$1|Z|3|10|5|I|7|1W|8|@$P|1X|Q|1Y|R|S]]|9|@]|A|$]]|$1|11|3|12|5|F|7|1Z|8|@$P|20|Q|21|R|S]]|9|@]|A|$]]|$1|13|3|-4|5|6|7|22|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|23|8|@]|9|@]|A|$]]|$1|15|3|16|5|6|7|24|8|@$P|25|Q|26|R|S]]|9|@]|A|$]]|$1|17|3|-4|5|6|7|27|8|@]|9|@]|A|$]]|$1|18|3|19|5|I|7|28|8|@$P|29|Q|2A|R|S]]|9|@]|A|$]]|$1|1A|3|1B|5|I|7|2B|8|@$P|2C|Q|2D|R|S]]|9|@]|A|$]]|$1|1C|3|-4|5|6|7|2E|8|@]|9|@]|A|$]]|$1|1D|3|-4|5|6|7|2F|8|@]|9|@]|A|$]]]|1E|$]]

<h3>CHAR</h3>

<ol>
<li>Used to store character string value of fixed length.</li>
<li>The maximum no. of characters the data type can hold is 255 characters.</li>
<li>It's 50% faster than VARCHAR.</li>
<li>Uses static memory allocation.</li>
</ol>

<h3>VARCHAR</h3>

<ol>
<li>Used to store variable length alphanumeric data.</li>
<li>The maximum this data type can hold is up to

<ul>
<li>Pre-MySQL 5.0.3: 255 characters.</li>
<li>Post-MySQL 5.0.3: 65,535 characters shared for the row.</li>
</ul></li>
<li>It's slower than CHAR.</li>
<li>Uses dynamic memory allocation.</li>
</ol>

blocks|key|602426|text|CHAR+Vs+VARCHAR|type|unstyled|depth|inlineStyleRanges|entityRanges|data|602427|CHAR用于固定长度大小的变量|602428|VARCHAR用于可变长度大小的变量。|602429|例如。|602430|Create+table+temp
(City+CHAR(10),
Street+VARCHAR(10));

Insert+into+temp
values('Pune','Oxford');

select+length(city),+length(street)+from+temp;|code-block|syntax|javascript|602431|输出将是|602432|length(City)++++++++++Length(street)
10++++++++++++++++++++6|602433|结论:如果可变长度是可变的，为了有效地使用存储空间，必须使用VARCHAR而不是CHAR|602434|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|X|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|Y|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|10|8|@]|9|@]|A|$K|L]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

CHAR Vs VARCHAR

CHAR is used for Fixed Length Size Variable 
VARCHAR is used for Variable Length Size Variable.

E.g.

<pre><code>Create table temp
(City CHAR(10),
Street VARCHAR(10));

Insert into temp
values('Pune','Oxford');

select length(city), length(street) from temp;
</code></pre>

Output will be

<pre><code>length(City) Length(street)
10 6
</code></pre>

Conclusion: To use storage space efficiently must use VARCHAR Instead CHAR if variable length is variable

blocks|key|672396|text|CHAR(x)列只能恰好包含x字符。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|672397|VARCHAR(x)列最多可以包含x字符。|672398|因为您的MD5散列总是相同的大小，所以您可能应该使用CHAR。|672399|但是，您一开始就不应该使用MD5；它有一些已知的缺点。|672400|请改用SHA2。|672401|如果你在散列密码，你应该使用bcrypt。|672402|entityMap^0|0|7|E|1|0|0|A|H|1|0|Q|4|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]|$9|U|A|V|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|11|8|@$9|12|A|13|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|14|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|15|8|@]|D|@]|E|$]]|$1|N|3|O|5|6|7|16|8|@]|D|@]|E|$]]|$1|P|3|-4|5|6|7|17|8|@]|D|@]|E|$]]]|Q|$]]

A <code>CHAR(x)</code> column can only have exactly <code>x</code> characters. 
A <code>VARCHAR(x)</code> column can have up to <code>x</code> characters.

Since your MD5 hashes will always be the same size, you should probably use a <code>CHAR</code>.

However, you shouldn't be using MD5 in the first place; it has known weaknesses. 
Use SHA2 instead. 
If you're hashing passwords, you should use bcrypt.

blocks|key|2080726|text|在MySQL中，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2080727|和CHAR有什么区别？|blockquote|2080728|2080729|2080730|对于已经给出的答案，我想补充的是，在OLTP系统或频繁更新的系统中，甚至对于可变大小的列，也可以考虑使用CHAR，因为在更新期间可能会出现VARCHAR列碎片。|offset|length|style|CODE|2080731|我正在尝试存储MD5散列。|2080732|2080733|如果安全性真的很重要，MD5散列不是最佳选择。但是，如果您要使用任何散列函数，请考虑为其使用BINARY类型(例如，MD5将生成16字节的散列，因此对于表示十六进制数字的32个字符，BINARY(16)将足够代替CHAR(32)。这将节省更多的空间并提高性能。|2080734|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/Online_transaction_processing^0|0|0|0|0|1G|4|1X|7|I|4|0|0|0|0|1A|6|2J|A|2Y|8|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|10|8|@]|9|@]|A|$]]|$1|E|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|13|8|@$I|14|J|15|K|L]|$I|16|J|17|K|L]]|9|@$I|18|J|19|1|1A]]|A|$]]|$1|M|3|N|5|6|7|1B|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1D|8|@$I|1E|J|1F|K|L]|$I|1G|J|1H|K|L]|$I|1I|J|1J|K|L]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y]]]]

<blockquote>
 What's the difference between VARCHAR and CHAR in MySQL?
</blockquote>

To already given answers I would like to add that in <a href="http://en.wikipedia.org/wiki/Online_transaction_processing" rel="noreferrer" title="OLTP">OLTP</a> systems or in systems with frequent updates consider using <code>CHAR</code> even for variable size columns because of possible <code>VARCHAR</code> column fragmentation during updates.

<blockquote>
 I am trying to store MD5 hashes.
</blockquote>

MD5 hash is not the best choice if security really matters. However, if you will use any hash function, consider <code>BINARY</code> type for it instead (e.g. MD5 will produce 16-byte hash, so <code>BINARY(16)</code> would be enough instead of <code>CHAR(32)</code> for 32 characters representing hex digits. This would save more space and be performance effective.

blocks|key|602268|text|如果输入的字符长度短于声明的长度，则Varchar会截断尾随空格，而char则不会。Char将填充空格，并将始终为声明长度的长度。在效率方面，varchar更熟练，因为它修剪字符以允许更多的调整。但是，如果您知道char的确切长度，char的执行速度会更快一些。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|602269|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Varchar cuts off trailing spaces if the entered characters is shorter than the declared length, while char will not. Char will pad spaces and will always be the length of the declared length. In terms of efficiency, varchar is more adept as it trims characters to allow more adjustment. However, if you know the exact length of char, char will execute with a bit more speed.

blocks|key|602229|text|CHAR是固定长度的字段；VARCHAR是可变长度的字段。如果要存储长度变化很大的字符串，如名称，则使用VARCHAR，如果长度始终相同，则使用CHAR，因为它的大小效率稍高一些，而且速度也稍快一些。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|602230|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

CHAR is a fixed length field; VARCHAR is a variable length field. If you are storing strings with a wildly variable length such as names, then use a VARCHAR, if the length is always the same, then use a CHAR because it is slightly more size-efficient, and also slightly faster.

blocks|key|1903028|text|在今天的大多数RDBMS中，它们是同义词。但是，对于那些仍然有区别的系统，CHAR字段存储为固定宽度的列。如果将其定义为CHAR(+10+)，那么将向表中写入10个字符，其中“填充”(通常是空格)用于填充数据未用完的任何空格。例如，保存"bob“将保存为("bob"%2B7个空格)。VARCHAR+(可变字符)列用于存储数据，而不会浪费CHAR列所做的额外空间。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1903029|像往常一样，Wikipedia的声音更大了。|offset|length|1903030|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/Varchar^0|0|6|9|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

In most RDBMSs today, they are synonyms. However for those systems that still have a distinction, a CHAR field is stored as a fixed-width column. If you define it as CHAR(10), then 10 characters are written to the table, where "padding" (typically spaces) is used to fill in any space that the data does not use up. For example, saving "bob" would be saved as ("bob"+7 spaces). A VARCHAR (variable character) column is meant to store data without wasting the extra space that a CHAR column does.

As always, <a href="http://en.wikipedia.org/wiki/Varchar" rel="noreferrer">Wikipedia</a> speaks louder.

blocks|key|602196|text|CHAR是固定长度，VARCHAR是可变长度。CHAR始终为每个条目使用相同数量的存储空间，而VARCHAR仅使用存储实际文本所需的空间。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|602197|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

CHAR is fixed length and VARCHAR is variable length. CHAR always uses the same amount of storage space per entry, while VARCHAR only uses the amount necessary to store the actual text.

blocks|key|2081026|text|字符|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2081027|2081028|CHAR是固定长度的字符串数据类型，因此字段中的任何剩余空间都用空格填充。|unordered-list-item|2081029|CHAR占用每个字符1个字节。因此，无论CHAR(+100+)字段(或变量)包含的字符串是什么，它都会占用磁盘上的100个字节。|2081030|2081031|VARCHAR|2081032|2081033|VARCHAR是一种可变长度字符串数据类型，因此它只包含分配给它的字符。|2081034|VARCHAR每个字符占用1个字节，%2B2个字节用于保存长度信息(例如，如果设置VARCHAR(100)数据类型=‘Dhanika’，则它将占用7个字节(对于D、H、A、N、I、K和A)外加2个字节，或总共9个字节。)|2081035|2081036|entityMap^0|0|2|0|0|0|0|0|0|7|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|10|8|@]|D|@]|E|$]]|$1|J|3|K|5|I|7|11|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|12|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|13|8|@$9|14|A|15|B|C]]|D|@]|E|$]]|$1|O|3|-4|5|6|7|16|8|@]|D|@]|E|$]]|$1|P|3|Q|5|I|7|17|8|@]|D|@]|E|$]]|$1|R|3|S|5|I|7|18|8|@]|D|@]|E|$]]|$1|T|3|-4|5|6|7|19|8|@]|D|@]|E|$]]|$1|U|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|V|$]]

CHAR
<ul>
<li>CHAR is a fixed length string data type, so any remaining space in the field is padded with blanks.</li>
<li>CHAR takes up 1 byte per character. So, a CHAR(100) field (or variable) takes up 100 bytes on disk, regardless of the string it holds.</li>
</ul>
VARCHAR
<ul>
<li>VARCHAR is a variable length string data type, so it holds only the characters you assign to it.</li>
<li>VARCHAR takes up 1 byte per character, + 2 bytes to hold length information (For example, if you set a VARCHAR(100) data type = ‘Dhanika’, then it would take up 7 bytes (for D, H, A, N, I, K and A) plus 2 bytes, or 9 bytes in all.)</li>
</ul>

blocks|key|1903287|text|字符|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1903288|1903289|Uses+allocation+of+memory|ordered-list-item|1903290|Time+efficient|1903291|1903292|VARCHAR|1903293|1903294|使用memory|1903295|Memory+efficient|1903296|的动态分配|1903297|entityMap^0|0|2|0|0|0|0|0|0|7|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|10|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|11|8|@]|D|@]|E|$]]|$1|J|3|K|5|I|7|12|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|13|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|14|8|@$9|15|A|16|B|C]]|D|@]|E|$]]|$1|O|3|-4|5|6|7|17|8|@]|D|@]|E|$]]|$1|P|3|Q|5|I|7|18|8|@]|D|@]|E|$]]|$1|R|3|S|5|I|7|19|8|@]|D|@]|E|$]]|$1|T|3|U|5|6|7|1A|8|@]|D|@]|E|$]]|$1|V|3|-4|5|6|7|1B|8|@]|D|@]|E|$]]]|W|$]]

CHAR
<ol>
<li>Uses specific allocation of memory</li>
<li>Time efficient</li>
</ol>
VARCHAR
<ol>
<li>Uses dynamic allocation of memory</li>
<li>Memory efficient</li>
</ol>

blocks|key|602383|text|char是固定长度的字符数据类型，varchar是可变长度的字符数据类型。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|602384|由于char是固定长度的数据类型，因此char值的存储大小等于此列的最大大小。因为varchar是可变长度的数据类型，所以varchar值的存储大小是输入数据的实际长度，而不是此列的最大长度。|602385|当一列中的数据条目预期大小相同时，可以使用char。当一列中的数据条目的大小预计会有很大变化时，可以使用varchar。|602386|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

The char is a fixed-length character data type, the varchar is a variable-length character data type.

Because char is a fixed-length data type, the storage size of the char value is equal to the maximum size for this column. Because varchar is a variable-length data type, the storage size of the varchar value is the actual length of the data entered, not the maximum size for this column.

You can use char when the data entries in a column are expected to be the same size.
You can use varchar when the data entries in a column are expected to vary considerably in size.

blocks|key|602521|text|区分两者对于完整性方面也是有好处的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|602522|如果您希望存储具有长度规则(如yes或no+)的内容，则可以使用char(1)来存储Y或N。对于货币代码等内容，您可以使用char(3)来存储USD、EUR或AUD等内容。|602523|那么varchar更适合，因为除了限制之外，没有关于它们长度的一般规则。它对于名称或描述之类的东西很有用，在这些东西中，值的长度有很多变化。|602524|然后text数据类型出现了，并将一个扳手放在工作中(尽管它通常只是varchar，没有定义上限)。|602525|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Distinguishing between the two is also good for an integrity aspect.
If you expect to store things that have a rule about their length such as yes or no then you can use char(1) to store Y or N. Also useful for things like currency codes, you can use char(3) to store things like USD, EUR or AUD.
Then varchar is better for things were there is no general rule about their length except for the limit. It's good for things like names or descriptions where there is a lot of variation of how long the values will be.
Then the text data type comes along and puts a spanner in the works (although it's generally just varchar with no defined upper limit).

blocks|key|672900|text|根据High+Performance+MySQL的书：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|672901|672902|+VARCHAR存储可变长度字符串，是最常见的字符串数据类型。与固定长度的类型相比，它需要的存储空间更少，因为它只使用所需的空间(即，用于存储较短的值的空间更少)。例外情况是使用ROW_FORMAT=FIXED创建的MyISAM表，它为每行使用固定数量的磁盘空间，因此可能会浪费空间。VARCHAR有助于提高性能，因为它节省了空间。|blockquote|style|BOLD|672903|672904|CHAR是固定长度的:+MySQL总是为指定数量的字符分配足够的空间。存储CHAR值时，MySQL将删除所有尾随空格。(这也适用于MySQL+4.1及更早版本中的VARCHAR+-+CHAR和VAR+CHAR在逻辑上是相同的，只是存储格式不同。)值根据比较需要用空格填充。|672905|entityMap|0|LINK|mutability|MUTABLE|url|https://rads.stackoverflow.com/amzn/click/com/1449314287^0|2|M|0|0|0|1|7|3Y|C|0|0|0|4|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]|$1|E|3|F|5|G|7|Z|8|@$A|10|B|11|H|I]|$A|12|B|13|H|I]]|9|@]|C|$]]|$1|J|3|-4|5|6|7|14|8|@]|9|@]|C|$]]|$1|K|3|L|5|6|7|15|8|@$A|16|B|17|H|I]]|9|@]|C|$]]|$1|M|3|-4|5|6|7|18|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

according to <a href="https://rads.stackoverflow.com/amzn/click/com/1449314287" rel="nofollow noreferrer" rel="nofollow noreferrer">High Performance MySQL</a> book: 

<blockquote>
 VARCHAR stores variable-length character strings and is the most common string data type. It can require less storage space than
 fixed-length types, because it uses only as much space as it needs
 (i.e., less space is used to store shorter values). The exception is a
 MyISAM table created with ROW_FORMAT=FIXED, which uses a fixed amount
 of space on disk for each row and can thus waste space. VARCHAR helps
 performance because it saves space. 
 
 CHAR is fixed-length: MySQL always allocates enough space for the specified number of characters. When storing a CHAR value, MySQL
 removes any trailing spaces. (This was also true of VARCHAR in MySQL
 4.1 and older versions—CHAR and VAR CHAR were logically identical and differed only in storage format.) Values are padded with spaces as
 needed for comparisons.
</blockquote>

blocks|key|672845|text|Char有固定长度(支持2000个字符)，它代表字符是一种数据类型|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|672846|Varchar具有可变长度(支持4000个字符)|672847|entityMap^0|0|4|0|0|7|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

<code>Char</code> has a fixed length (supports 2000 characters), it is stand for character is a data type 

<code>Varchar</code> has a variable length (supports 4000 characters)

blocks|key|1903125|text|Char或varchar-用于输入文本数据，其中长度可以在括号中表示，例如-+name+char+(20)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1903126|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Char or varchar- it is used to enter texual data where the length can be indicated in brackets
Eg- name char (20)

blocks|key|672783|text|字符:|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|672784|Character和Numbers.|672785|Supports+2000+characters.|unordered-list-item|672786|
|672787|Fixed+Length都支持|672788|。|672789|672790|672791|VARCHAR+:|672792|Character+&+Numbers.|672793|Supports+4000+characters.|672794|672795|Variable+Length均支持|672796|672797|672798|672799|任何评论......！|672800|entityMap^0|0|3|0|0|0|0|0|0|0|0|0|9|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1B|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|1C|8|@]|D|@]|E|$]]|$1|K|3|L|5|6|7|1D|8|@]|D|@]|E|$]]|$1|M|3|N|5|J|7|1E|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|1F|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|1G|8|@]|D|@]|E|$]]|$1|R|3|-4|5|6|7|1H|8|@]|D|@]|E|$]]|$1|S|3|T|5|6|7|1I|8|@$9|1J|A|1K|B|C]]|D|@]|E|$]]|$1|U|3|V|5|6|7|1L|8|@]|D|@]|E|$]]|$1|W|3|X|5|J|7|1M|8|@]|D|@]|E|$]]|$1|Y|3|L|5|6|7|1N|8|@]|D|@]|E|$]]|$1|Z|3|10|5|J|7|1O|8|@]|D|@]|E|$]]|$1|11|3|P|5|J|7|1P|8|@]|D|@]|E|$]]|$1|12|3|-4|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|13|3|-4|5|6|7|1R|8|@]|D|@]|E|$]]|$1|14|3|15|5|6|7|1S|8|@]|D|@]|E|$]]|$1|16|3|-4|5|6|7|1T|8|@]|D|@]|E|$]]]|17|$]]

CHAR : 

<ul>
<li>Supports both Character &amp; Numbers.</li>
<li>Supports 2000 characters.</li>
<li>Fixed Length.</li>
</ul>

VARCHAR :

<ul>
<li>Supports both Character &amp; Numbers.</li>
<li>Supports 4000 characters.</li>
<li>Variable Length.</li>
</ul>

any comments......!!!!

What's the difference between VARCHAR and CHAR in MySQL?

I am trying to store MD5 hashes.

What's the difference between VARCHAR and CHAR?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

在MySQL中，VARCHAR和CHAR有什么不同？我正在尝试存储MD5散列。

问VARCHAR和CHAR有什么区别？
EN

回答 17

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问VARCHAR和CHAR有什么区别？EN

回答 17

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问VARCHAR和CHAR有什么区别？
EN