Danny,
If you are storing text, make the column type text--depending on how much data you are
storing, you may prefer tinytext, text, mediumtext or longtext. Then you just need to
mysql_escape_string() before saving to db.
Reference for mysql_escape_string():
http://us2.php.net/manual/en/function.mysql-escape-string.php
Randy Clamons
Systems Programming
Astro-auction.com
> ------------Original Message------------
> From: "Danny Willis" <danny.willis@stripped>
> To: "'James Frankman'" <jfrankman@stripped>, win32@stripped
> Date: Wed, Dec-8-2004 3:36 PM
> Subject: RE: Help with using Text and Blob types
>
>
> I'm using php, not asp/vb.
>
>
> -----Original Message-----
> From: James Frankman [mailto:jfrankman@stripped]
> Sent: Wednesday, December 08, 2004 5:34 PM
> To: Danny Willis
> Subject: RE: Help with using Text and Blob types
>
> Assuming you are using vb or asp, this article help me out:
> http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html
>
> -----Original Message-----
> From: Danny Willis [mailto:danny.willis@stripped]
> Sent: Wednesday, December 08, 2004 3:26 PM
> To: win32@stripped
> Subject: Help with using Text and Blob types
>
>
> I have a site with a form that takes in a message. At the moment I
> have it
> set as a VARCHAR but it isn't large enough. What's the trick to
> changing
> the type to a Text Type of Blob type and working with it? I've read
> the
> documentation but I still really don't understand what I need to change
> in
> my queries to work with these types.
>
> This is a priority so any help is greatly appreciated.
>
> Thanks.
>
>
