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 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 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 的大作中提到】![](/moin_static193/solenoid/img/up.png) : Yeah, of course, why not use LONGBLOB or LONGTEXT?
| c****d 发帖数: 116 | 4 You need escape these escape chars. Check manual please.:))
【在 s***m 的大作中提到】![](/moin_static193/solenoid/img/up.png) : : 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
|
|