I am having a problem with TEXT fields and MEDIUMTEXT fields. The smaller of the two of these ids supposed to hold over 65k characters.
I created a test table and set one of the fields to TEXT. When I tried to insert a record the text column stopped accepting after about 250 characters. I figured I could deal with this by using a MEDIUMTEXT field, but it does the same thing.
I am using mysqld-opt and entering SQL into the command line. Does anyone know why I am having this problem? Do I need to add something to the my.cnf file?
I am trying to break my MS addiction one step at a time and could use a little help with this problem.
The window stops accepting input. It's going, going, and it just stops in the middle of a wor
It wont let me put in any more characters. I have to back up two spaces just to close the statment (the '
-edit- this was not supposed to be a smiley, it's the ' and the ; at the end of the statement -/edit-
This is really driving me crazy I started with the excellent article here on SP and everything is working except for this db problem. I have looked every place I can think of, mysql.com, the manual, all of my (2) smart friends...
You're using DOS, yes?
It isn't actually MySQL...it's DOS limiting your input. You can try one of two things:
First, do as Defender suggested. When you get to the point of not being able to type anymore, hit backspace once and hit enter and continue typing. Repeat this as many times as necesssary.
Or put your input into a PHP file and use PHP to insert it into the database.
I did the enter and then add more text. That worked but it adds extra space to the table. Since I am learning mysql to support php data site, i will just use forms to add the content. I was doing it manually just to get up-close and personal with sql.