简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

TEXT、TINYTEXT、MEDIUMTEXT、LONGTEXT选择

WBOY
Release： 2016-06-07 15:54:26
Original
2254 people have browsed it

在mysql里面储存不区分大小写的字符数据： TINYTEXT 最大长度是 255 (2^8 - 1) 个字符。 TEXT 最大长度是 65535 (2^16 - 1) 个字符。 MEDIUMTEXT 最大长度是 16777215 (2^24 - 1) 个字符。 LONGTEXT 最大长度是 4294967295 (2^32 - 1) 个字符

在mysql里面储存不区分大小写的字符数据：

TINYTEXT 最大长度是 255 (2^8 - 1) 个字符。

TEXT 最大长度是 65535 (2^16 - 1) 个字符。

MEDIUMTEXT 最大长度是 16777215 (2^24 - 1) 个字符。

LONGTEXT 最大长度是 4294967295 (2^32 - 1) 个字符
Related labels：
text
source：php.cn
Previous article：Oracle IMP-00010、IMP-00031的解决 Next article：Giraph源码分析启动ZooKeeper服务
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
Latest Articles by Author
Latest Issues
MySQL: "Select text from... as <variable here or subquery>" I have the following table with the following data: id text language 1 german text german ...
From 2024-04-06 19:25:54
0
2
529
Unable to get input element from website So I'm trying to get an input element from Twitter, but when I run it it keeps giving me a...
From 2024-04-06 18:59:57
0
1
442
Align tooltip to relative parent I spent two days trying to solve this problem but I realized I couldn't do it alone. I'm t...
From 2024-04-06 13:16:59
0
2
394
Display an element after a block newline I currently have this: I want to put the icon div at the end of the text, but since it's a...
From 2024-04-04 21:45:21
0
1
271
Center dropdown menu in navigation bar I made this CSS/HTML. .navbar{width:100%;background-color:rgb(151,44,44);overflow:auto;}.n...
From 2024-04-04 18:24:52
0
1
338
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！