more useful options | |
PerlMonks |
Re: Re: MySQL Blob / DBI quote ?by Anonymous Monk |
on Dec 20, 2003 at 21:28 UTC ( [id://316096]=note: print w/replies, xml ) | Need Help?? |
Hey - I further read more on the quote option and that was totally the wrong direction to fix my problem. I'm trying to add memo's to a database, some memos are way more the 255 characters so I changed the "memo_text" field into a blob columntype instead of "varchar(255) not null." Heres my code:
Now, previously when the column type was "varchar(255) not null" , this insert code worked fine and all memos were added successfully. But when I altered the table to make it a blob column type this insert code returns a error giving me:
Part of that error message is due to the fact that the memo I tried insterting included the sentence 'I've been trying to figure out how come this doesn't work for me. I have a insert ' Thank you, Anthony
In Section
Seekers of Perl Wisdom
|
|