List:General Discussion« Previous MessageNext Message »
From:Rhino Date:August 18 2004 8:05pm
Subject:Re: Strange Text Field
View as plain text  
----- Original Message ----- 
From: "Stuart Felenstein" <stuart4m@stripped>
To: <mysql@stripped>
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

Thread
Strange Text FieldStuart Felenstein18 Aug
  • Re: Strange Text FieldRhino18 Aug
    • Re: Strange Text FieldStuart Felenstein18 Aug
    • Re: Strange Text FieldStuart Felenstein18 Aug
RE: Strange Text FieldVictor Pendleton18 Aug
  • RE: Strange Text FieldStuart Felenstein18 Aug
  • RE: Strange Text FieldStuart Felenstein18 Aug
    • Re: Strange Text FieldDan Nelson18 Aug
      • Re: Strange Text FieldStuart Felenstein18 Aug
    • RE: Strange Text Field(Terry Riley)19 Aug
RE: Strange Text FieldVictor Pendleton18 Aug
  • RE: Strange Text FieldStuart Felenstein18 Aug