The checking is done from the mysql command line tool and all special characters are properly quoted (even tried it with a sequence of characters without any punctuation marks or anything else). The mysql_query() call has a die() statement as well but it is not coming up.
George "I think there is a world market for maybe five computers." Thomas Watson, Chairman of IBM, 1943. ----- Original Message ----- From: "gerald_clark" <[EMAIL PROTECTED]> To: "Lekeas GK" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, July 18, 2003 3:00 PM Subject: Re: Working with the text datatype in Mysql | | | Lekeas GK wrote: | | >Gerald, | > | >The version of MySQL is 3.23, | > | That only spans 50 some odd releases. Which one? | | > the platform is Solaris, the language is | >English | > | Computer language. | PHP? | Perl? | Python? | Mysql command line tool? | | Did the program performing the insert properly quote special characters? | Did it check for sucess of the insert? | | > and the way I check whether data has been entered in the database or | >not is by running a select query on the database. | > | Useing Which language above? | | > | >Was that of any help? I tried searching the net but couldn't find more | >information about what might be causing the problem... | > | >Thanks, | >George | > | >"I think there is a world market for maybe five computers." | >Thomas Watson, Chairman of IBM, 1943. | > | >----- Original Message ----- | >From: "gerald_clark" <[EMAIL PROTECTED]> | >To: "Lekeas GK" <[EMAIL PROTECTED]> | >Cc: <[EMAIL PROTECTED]> | >Sent: Friday, July 18, 2003 2:11 PM | >Subject: Re: Working with the text datatype in Mysql | > | > | >| You supply almost no useful information here. | >| What version of MySQL are you using? | >| What platform? | >| What language? | >| How do you check to see if anything was entered? | >| | >| | >| Lekeas GK wrote: | >| | >| >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/[EMAIL PROTECTED]
