Mysql limits - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Mysql limits

Mysql limits# Database - 数据库

s*m2000-12-08 08:12

1 楼

Is there a limit in size for the data type of text in Mysql?
I try to insert a very
large text file but the server fails to take it. If i cut
the size of the text,
i take it smoothly. Thanks.

c*d2000-12-08 08:12

2 楼

Yeah, of course, why not use LONGBLOB or LONGTEXT?

【在 s***m 的大作中提到】

: Is there a limit in size for the data type of text in Mysql?
: I try to insert a very
: large text file but the server fails to take it. If i cut
: the size of the text,
: i take it smoothly. Thanks.

s*m2000-12-08 08:12

3 楼

I try to use longtext for the field. However, if the string
that i create contains
new line, the server fails to accept it. For examples, if i
create a simple GUI
for mail composer, if i want to allow user to type in their
message into textarea and then
use a servlet to fetch the content in textarea as a string,
i am not able to insert
them into mysql because of the Indent and newline. How can i
do that?

【在 c****d 的大作中提到】

: Yeah, of course, why not use LONGBLOB or LONGTEXT?

c*d2000-12-08 08:12

4 楼

You need escape these escape chars. Check manual please.:))

【在 s***m 的大作中提到】

:
: I try to use longtext for the field. However, if the string
: that i create contains
: new line, the server fails to accept it. For examples, if i
: create a simple GUI
: for mail composer, if i want to allow user to type in their
: message into textarea and then
: use a servlet to fetch the content in textarea as a string,
: i am not able to insert
: them into mysql because of the Indent and newline. How can i