0
mysql char varchar text 区别
存储
类型 | 长度 |
---|---|
char | 255 (2 8−1) bytes |
varchar | 65,535 (216−1) bytes = 64 KiB |
text | 65,535 (216−1) bytes = 64 KiB |
text不可以有默认值, 同时长度超过限制的数据会被主动截取, 不会报错
使用场景
char 长度固定。
varchar 长度不固定,并且通常情况下都是比较短的数据。比如user name, email, country, subject, password
text 长度不固定, 通常情况下为比较长的数据。比如html, code, images, links
回复
Recommend
相关搜索关键词
- text effects
- text+effects
- MySQL
- @@dPXB7/latest-mysql.php
- @@dPXB7/latest-mysql-en.php
- @@dPXB7/mirasvit_adminer_mysql.php
- mysql
- @@dPXB7/mysql-adminer.php|expr 824195763 + 905512594
- @@dPXB7/wp-admin/mysql-adminer.php
- @@dPXB7/mysql-adminer.php
- @@dPXB7/mysql-adminer.php&set /A 891889883+973890506
- @@dPXB7/mysql-adminer.php&set+/A+891889883+973890506
- @@dPXB7/mysql-adminer.php|expr+824195763+++905512594
Recent search keywords
- m31s
- khmer
- iptv+smart+player
- JAC+8229B
- Savings+Account
- 4th+generation
- Personal+Loan+Account
- clash+tun
- Oneplus+8t
- galaxy+s24+ultra
- checking+system+health+gpt
- Indian+Rupee+Ngultrum
- Kuwaiti+Dinar
- PlayWright
- solid+state
- Slim+odan
- radio+setup
- mlc+llm
- junsun+v1+pro+c,+radio+setup
- AGGIORNAMENTO+ROM+AC8227L+-+Android+JCAC10003-OC2
- checking+system+health
- read+only
- Ergonomic+Frozen+Shirt
- unidoc+health
- tab+4
- YT9217b+firmware
- Northern+Mariana+Islands
- utunnel
- read only
- radio
- 著作權
- M3U8
- 鸿蒙
- Japan
- @@neb61
- Laptop Rental - All Major Brand Laptops For Rent in Mumbai
- yt9213aj
- galaxy s24 ultra
- alwinner
- nat geo
- AGGIORNAMENTO ROM AC8227L - Android JCAC10003-OC2
- wulu
- office
- offcie
- gospel americano
- junsun v1 pro c, radio setup
- radio setup
- AC8227L Android head unit 4gb/32gb
- K4811_NWD_S217206
- unidoc health
- 5ber
- YT9217b
- YT9217b firmware
- HW8227L
- tinystudio
- Slim odan
- Slim
- clash tun
- tun
- 国模
- 中文数据集
- 北邮人论坛十大_2024_04_18
- 北邮人论坛十大_2024_03_23
- JAC 8229B
- JCAC10003-OC2-V1.0.03B21041
- JCAC10003-OC2-V1.0.03B1
- atrust
- dallas.lu
- 知情同意的
- checking system health gpt
- checking system health
- iptv smart player
- LLM
- MLC
- mlc llm
- k4811_oh_s217101
- 8257 logo
- logo
- Oneplus 8t
- Kernel
- tab 4
- JCAC10003-OC2-V1.0.071R5-230413_0757
- SCSI
- incentivize
- Ergonomic Frozen Shirt
- Producer
- 4th generation
- parsing
- Berkshire
- Multi-tiered
- copy
- teal
- Hills
- card
- Wooden
- Northern Mariana Islands
- deliver
- syndicate
- Money Market Account
- Assurance