MySQL Forums
Forum List  »  Microsoft SQL Server

MySQL TEXTPTR equiv? write large blob?
Posted by: fname lname
Date: February 22, 2007 04:04AM

Hello,

I'm trying to port some MSSQL / TSQL code over to MySQL. I'm having a problem with writing to large blobs though. MSSQL provides something called TEXTPTR and UPDATETEXT. What this allows you to do is select a pointer to a blob. You can then write to the blob with following UPDATETEXT SQL commands using the pointer (from TEXTPTR) and a blob offset. That setup is perfect for us because we're allowing users store blobs of upto 1GB. Holding the entire blob in memory to issue a single INSERT or UPDATE statement is not feasible. Any suggestions?


Thanks you,

Kyle

Options: ReplyQuote


Subject
Written By
Posted
MySQL TEXTPTR equiv? write large blob?
February 22, 2007 04:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.