Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

text/blob types' maximum lengths are wrong #4014

Closed
cyliu0 opened this issue Oct 9, 2020 · 3 comments · Fixed by #11155
Closed

text/blob types' maximum lengths are wrong #4014

cyliu0 opened this issue Oct 9, 2020 · 3 comments · Fixed by #11155
Assignees

Comments

@cyliu0
Copy link

cyliu0 commented Oct 9, 2020

Error Report

This repository is ONLY used to solve issues related to DOCS.
For other issues (related to TiDB, PD, etc), please move to other repositories.

Please answer the following questions before submitting your issue. Thanks!

  1. What is the URL/path of the document related to this issue?
    https://docs.pingcap.com/tidb/stable/data-type-string#longblob-type

The MEDIUMBLOB type is similar to the BLOB type. The difference is that the maximum column length of MEDIUMBLOB is 16,777,215.
The LONGBLOB type is similar to the BLOB type. The difference is that the maximum column length of LONGBLOB is 4,294,967,295.

  1. How would you like to improve it?
    According to the TiDB Limitations, The limitation of size on a single column/row is 6MB. But the maximum lengths of medium/long text/blob are over 6MB a lot which are 16MB and 4GB.
@TomShawn
Copy link
Contributor

TomShawn commented Nov 12, 2020

@wjhuang2016 Please help take a look, thanks!

@morgo
Copy link
Contributor

morgo commented Jan 7, 2021

This also relates to #4390 (There is no actual storage size details on this page)

@TomShawn
Copy link
Contributor

Looks like this document (https://docs.pingcap.com/tidb/dev/data-type-string) needs technical correction and more information for users.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants