----- Original Message ----- From: "Stuart Felenstein" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 18, 2004 3:49 PM Subject: Strange Text Field
> Hoping I can figure this out. Using MySQl > 4.0.20-Standard. > > I have a table (tried this both myISAM and Innodb) > with 12 fields, 3 are ints, 7 are varchars and 1 is > set to text. > Form is using a textarea for input into the text > field. Basically a copy and paste of rich text. (I'm > not concerned with formatting right now) > > Anyway it won't take and returns a vague SQL syntax > error. If I try to input it directly into the database > I get an error about the grid being 12 columns and the > clipboard being 1 column. Yet I had all the other > fields filled in. And all but the ID is set to allow > nulls. > > Frustrated to figure out why this is occuring I > created a table with 2 fields, one for the recordID, > the other for the text dump. Works like a charm. > > So has anyone seen this before ? It seems odd , I've > searched the manual and bug base and came up with > nothing. > Unless someone can quickly identify it is as a well-known issue, I suggest that you supply some code fragments that show what you're doing, as well as any error messages you are getting. Right now, we don't even know what language you're using, let alone what might be wrong in your code. I have successfully copied regular text from a form text field to a MySQL table but I've never tried rich text; I'm not even sure how to get rich text *into* a text field on a form. I might use a clipboard that is sensitive to rich text to get the rich text onto the form field but I wouldn't have thought of using it to transfer data between the form and MySQL. Therefore, I can't even visualize roughly how you're doing what you're doing let alone what sort of coding error you might have made. I suspect I speak for others on this list, too. Does your program store the data correctly if you just put regular text in the form field, rather than rich text? That might help determine if this is some kind of encoding/codepage problem. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
