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 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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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 =...
|
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 =...
|
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...
|
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...
|
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...
|
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.
|
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,...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
| |