Rob, The script is indeed written in PHP version 4.3.1. The full version of mysql I am using is 3.23.30-gamma.
Thanks, George "I think there is a world market for maybe five computers." Thomas Watson, Chairman of IBM, 1943. ----- Original Message ----- From: "Rob A. Brahier" <[EMAIL PROTECTED]> To: "Lekeas GK" <[EMAIL PROTECTED]> Sent: Friday, July 18, 2003 4:31 PM Subject: RE: Working with the text datatype in Mysql | George, | You keep leaving out the vital bits. What are your sers using to enter | this data? We know it's a web page, but what script does that web page run | when the user submits their data? Is it a script written in the PHP | programming language or something else? What is the FULL version number of | the MySQL server you are using, and what is the version of the programming | language that you wrote your script in? | | -Rob | | -----Original Message----- | From: Lekeas GK [mailto:[EMAIL PROTECTED] | Sent: Friday, July 18, 2003 10:17 AM | To: gerald_clark | Cc: [EMAIL PROTECTED] | Subject: Re: Working with the text datatype in Mysql | | | 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]
