MySQL VarChar 255 及以上 [英] MySQL VarChar 255 and above
问题描述
我目前正在执行屏幕抓取并存储到 MySQL 数据库中,我使用了一些列作为 answer_content varchar(255) NOT NULL,
但问题是一些数据被截断,我正在阅读以下 博客文章.
I am currently doing screen scraping and storing in to a MySQL database, I used some of my columns as answer_content varchar(255) NOT NULL,
but the problem is some of the data is getting truncated, I was reading following blog post.
但我不确定这是否是解决方案:在不截断文本的情况下保存文本的最佳解决方案是什么?我不是在服务器端这样做,而是在个人笔记本电脑上这样做.
But I am not really sure if that is the solution: What is the best solution to save the text without getting them truncated? I am not doing this on a server side and currently doing on a person laptop.
推荐答案
将类型更改为 TEXT
Change type to TEXT
请参考:http://www.electrictoolbox.com/maximum-length-mysql-文本字段类型/
这篇关于MySQL VarChar 255 及以上的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!