dongmu6578 2014-04-24 11:20
浏览 1015
已采纳

为什么MySQL允许VARCHAR(255)拥有更大的数字

When I first learnt about field types in MySQL I would define anything that was not a number as a VARCHAR and set the length to anything. 500 2000, but am I right in saying the maximum is actually 255?

If this is the case, why does MySQL let me define columns with much larger lengths and what is it actually doing? Will it allow larger lengths? Does it define the column / field as something else?

Any advice welcomed.

  • 写回答

5条回答 默认 最新

  • doushui5587 2014-04-24 11:24
    关注

    This behavior was changed after 5.0.3:

    Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions. The effective maximum length of a VARCHAR in MySQL 5.0.3 and later is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used.

    From The CHAR and VARCHAR Types documentation reference.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(4条)

报告相同问题?

悬赏问题

  • ¥20 怎么在stm32门禁成品上增加记录功能
  • ¥15 Source insight编写代码后使用CCS5.2版本import之后,代码跳到注释行里面
  • ¥50 NT4.0系统 STOP:0X0000007B
  • ¥15 想问一下stata17中这段代码哪里有问题呀
  • ¥15 flink cdc无法实时同步mysql数据
  • ¥100 有人会搭建GPT-J-6B框架吗?有偿
  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 解riccati方程组