s***m
发帖数: 28 | 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****d
发帖数: 116 | 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***m
发帖数: 28 | 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****d
发帖数: 116 | 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
|
|
