473,322 Members | 1,409 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Working with the text datatype in Mysql

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

Jul 19 '05 #1
2 4505
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

Jul 19 '05 #2
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

Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Lekeas GK | last post by:
Hi All, I am managing a small database and some of the tables need to be strings of an average length of about 2,000 characters. I decided to use the text datatype to store this information...
0
by: Lekeas GK | last post by:
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...
0
by: Mike Hillyer | last post by:
Hi Everyone; As I was perusing the MySQL documentation, I noticed that there is a lack of documentation regarding the MySQL SET datatype and the queries used to manipulate it. In fact, the...
0
by: Thomas | last post by:
Hi, I'm currently trying to display the contents of a field which datatype is set to TEXT, I'm trying to output this through a C program. the line is as follows: while((row =...
1
by: Thomas | last post by:
Hi, I'm currently trying to display the contents of a field which datatype is set to TEXT, I'm trying to output this through a C program. the line is as follows: while((row =...
2
by: Joel | last post by:
Hi, I'm importing our DOS data base (Dataflex) to Mysql I have a table with 174,638 records that I convert into a tab delimetered Text file however, Mysql only reads 87,035! I checked the text...
1
by: n4ixt | last post by:
I have two macros I used to use in VS 2003. I recently tried to import them for use in VS 2005, but they don't seem to work. I open the macro explorer, right click and do run, but it's like VS...
31
by: ajos | last post by:
hi frnds, i have a form,which has 2 input text boxes, the values are entering the text boxes,when i leave the 2 text boxes blank and hit submit a java script gives the message that the 2 fields are...
1
by: bipinskulkarni | last post by:
Is there any datatype in MYSQL which replaces XML Datatype? XML datatype i used in stored procedure for bulk input.
0
by: JamesOo | last post by:
I have the code below, but I need to make it searchable in query table, below code only allowed seach the table which in show mdb only. (i.e. have 3 table, but only can search either one only,...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.