List:General Discussion« Previous MessageNext Message »
From:Stuart Felenstein Date:August 18 2004 8:31pm
Subject:RE: Strange Text Field
View as plain text  
--- Victor Pendleton <VPendleton@stripped> wrote:

> Are both of these fields defined as blob datatypes?

Yes, the two tables (one working, one not) both are
set to text (I realize Blob is basically the same)


> Since one table works
> and the other does not work this leads me to
> question whether the
> application is performing consistently. Have you
> verified if data is entered
> into that does not display as expected?

It actually works better then expected and doesn't
require me to do any insert of new lines or tabs.  All
the data was returned 100% perfect. 

Stuart

> 
> -----Original Message-----
> From: Stuart Felenstein
> To: Victor Pendleton; 'mysql@stripped '
> Sent: 8/18/04 3:14 PM
> Subject: RE: Strange Text Field
> 
> In the table that fails, and the one that works, I'm
> using some products from a company called Interakt. 
> I
> mentioned this in my last reply, however didn't
> mention one part.  
> With this suite of tools , I can replace a text area
> with a mini html / cms tool.  Basic formatting etc.
> Now in the 2nd table where the insertion works. The
> form works great, retains all the formatting of the
> original document.
> 
> Stuart
> --- Victor Pendleton <VPendleton@stripped> wrote:
> 
> > What is the application you are using to insert
> and
> > retrieve the blob data?
> > Is the data actually being inserted? 
> > 
> > -----Original Message-----
> > From: Stuart Felenstein
> > To: mysql@stripped
> > Sent: 8/18/04 2: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. 
> > 
> > Thank you ,
> > Stuart
> > 
> > -- 
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> >
>
http://lists.mysql.com/mysql?unsub=1
> > 
> > -- 
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:   
> >
>
http://lists.mysql.com/mysql?unsub=1
> > 
> > 
> 

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