开发者

Maximum length for longtext field

开发者 https://www.devze.com 2023-01-27 19:17 出处:网络
I\'m developing a database driven website for a 开发者_JAVA技巧Chinese audience in PHP. The content is stored in the database as a longtext field.

I'm developing a database driven website for a 开发者_JAVA技巧Chinese audience in PHP. The content is stored in the database as a longtext field.

I was wondering how can I be sure the data to be stored isn't truncated?


It depends on the characters' sizes and some configuration options.

LONGTEXT [CHARACTER SET charset_name] [COLLATE collation_name]

A TEXT column with a maximum length of 4,294,967,295 or 4GB (2^32 – 1) characters. The effective maximum length is less if the value contains multi-byte characters. The effective maximum length of LONGTEXT columns also depends on the configured maximum packet size in the client/server protocol and available memory. Each LONGTEXT value is stored using a four-byte length prefix that indicates the number of bytes in the value.

http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html

0

精彩评论

暂无评论...
验证码 换一张
取 消