Re: RE: Text fields

2003-08-28 Thread Sreesekhar Palaparthy
max_allow_packet , but that's not a good option) On Thu, 28 Aug 2003 Rob wrote : For arbitrary sizes of text, try the MEDIUMTEXT or LONGTEXT column types. Data is then stored as a BLOB. Check out the docs at http://www.mysql.com/doc/en/BLOB.html -Original Message- From: Sreesekhar Palap

Text fields

2003-08-28 Thread Sreesekhar Palaparthy
Hi, How do we insert arbitary sized texts into MYSQL Text fields?? Is there any way to split the text into chunks and then append those chunks to the field??? ___ Art meets Army ; Swapna Weds Capt. Rajsekhar. Rediff Matchmaker strikes another i

Retrieving image files

2003-07-24 Thread Sreesekhar Palaparthy
I used mysql_real_escape_string() method to insert image file into database. Now how do icheck whether it got stored in proper format ?? I used SELECT * INTO OUTFILE F1 FROM IMGTABLE; command , but i'm not able to see the image back in F1. How do i retrieve the image in proper format?? __

Retreiving image files

2003-07-23 Thread Sreesekhar Palaparthy
I used mysql_real_escape_string() to insert jpg image file into database. Now how do i check whether it got stored in proper format?? I tried to retriev that image file using SELECT * INTO OUTFILE FROM IMGTABLE; But it says cannot open image file as it contains errors. How do i retrieve the i

Jpg file insertion

2003-07-17 Thread Sreesekhar Palaparthy
Hi, I want to store jpg files to BLOB field of a table. That table has other fields which are integer and char types. So i tried inserting image using LOAD DATA INTO .. statement . It got stored , but when i retrieve it back , i'm not able to see the image file.I hope it didn't get sto

Image files

2003-07-13 Thread Sreesekhar Palaparthy
Hi, How do i insert binary data into a BLOB field??? Like , if i have a table with say 3 fields of which 1 is blob type, now how do i store some binary file in that particular field??? Please help me out as i have to look put for some corresponding function in C++ API after that.Thank You

Image files

2003-07-06 Thread Sreesekhar Palaparthy
Hi, I want to save image files into BLOB fields?? How do i do it?? And how to retrieve it back from database?? ___ Click below to experience Sooraj R Barjatya's latest offering 'Main Prem Ki Diwani Hoon' starring Hrithik, Abhishek & Kareena http

BLOB fields

2003-07-04 Thread Sreesekhar Palaparthy
Hi, If i have a table having fields of different datatypes which include BLOB/TEXT type, how do i give an insert statement?? Can i give a query to insert only BLOB/TEXT field seperately? Please help me out. ___ Click below to experience S

Transaction support

2003-06-24 Thread Palaparthy
Hi, Does MYSQL support transaction concept, which includes issues like commiting data , rollbacking etc??? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]