Working with the text datatype in Mysql

[Lekeas GK]

Hi All,

I am managing a small database where a few fields are defined as being of
type text. In my understanding, this would allow the user to enter up to
about 65,000 characters in the text field.

However, if the user types about 2,000 characters, then nothing is entered
in the database. I have checked the max_packet_allowed and the
net_buffer_length and the limits are quite high.

Could somebody advice me on how to go about solving this problem?

I look forward to hearing from you soon.

Thanks in advance.

George

"I think there is a world market for maybe five computers."
Thomas Watson, Chairman of IBM, 1943.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

[2metre]

The problem is probably not the size of the string, but what is in it.

Are you using addslashes() before inserting it into the database?

""Lekeas GK"" <G.********@soi.city.ac.uk> wrote in message
news:bf***********@FreeBSD.csie.NCTU.edu.tw...

Hi All,

I am managing a small database where a few fields are defined as being of
type text. In my understanding, this would allow the user to enter up to
about 65,000 characters in the text field.

However, if the user types about 2,000 characters, then nothing is entered
in the database. I have checked the max_packet_allowed and the
net_buffer_length and the limits are quite high.

Could somebody advice me on how to go about solving this problem?

I look forward to hearing from you soon.

Thanks in advance.

George

"I think there is a world market for maybe five computers."
Thomas Watson, Chairman of IBM, 1943.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

[2metre]

The problem is probably not the size of the string, but what is in it.

Are you using addslashes() before inserting it into the database?

""Lekeas GK"" <G.********@soi.city.ac.uk> wrote in message
news:bf***********@FreeBSD.csie.NCTU.edu.tw...

Hi All,

I am managing a small database where a few fields are defined as being of
type text. In my understanding, this would allow the user to enter up to
about 65,000 characters in the text field.

However, if the user types about 2,000 characters, then nothing is entered
in the database. I have checked the max_packet_allowed and the
net_buffer_length and the limits are quite high.

Could somebody advice me on how to go about solving this problem?

I look forward to hearing from you soon.

Thanks in advance.

George

"I think there is a world market for maybe five computers."
Thomas Watson, Chairman of IBM, 1943.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw