RE: Problem with BLOB Field

2002-08-16 Thread Stephan Blanchard
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 14 August 2002 12:50 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Problem with BLOB Field I would be suspicious that the problem is with ADO or the underlying COM technology. The maximum size of a stri

Re: Problem with BLOB Field

2002-08-14 Thread bernd.grell
- >Hi, > >I have already posted this query 4-5 days ago but no >reply yet so posting 2nd time. > >Here is the query. > >Application Used: Visual Basic 6 >Database: MySQL 4.0.2 >ODBC: MyODBC 3.51.03 > >I have create a table which has BLOB field in which i >want to save a bitmap fil

Re: Problem with BLOB Field

2002-08-13 Thread Girish L Panchal
You may use ADO Stream object for retriving and saving BLOB data. >>> deep kapasi <[EMAIL PROTECTED]> 08/13/02 06:03PM >>> Hi, I have already posted this query 4-5 days ago but no reply yet so posting 2nd time. Here is the query. Application Used: Visual Basic 6 Database: MySQL 4.0.2 ODBC: MyO

RE: Problem with BLOB Field

2002-08-13 Thread jbonnett
: Tuesday, 13 August 2002 10:03 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Problem with BLOB Field Hi, I have already posted this query 4-5 days ago but no reply yet so posting 2nd time. Here is the query. Application Used: Visual Basic 6 Database: MySQL 4.0.2 ODBC

Re: Problem with BLOB Field

2002-08-13 Thread Mauricio Sthandier R.
Try ActualSize instead. - Original Message - From: "deep kapasi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 8:33 AM Subject: Problem with BLOB Field > Hi, > > I have al

RE: Problem with BLOB Field

2002-08-13 Thread Dave Watkinson
There was a reply posted last week --- James Frankman <[EMAIL PROTECTED]> wrote: > Blob limit is 64K use MEDIUMBLOB for your column and I got this from http://www.mysql.com/doc/en/Storage_requirements.html TINYBLOB, TINYTEXT L+1 bytes, where L < 2^8 BLOB, TEXT L+2 bytes, where L <

Problem with BLOB Field

2002-08-13 Thread deep kapasi
Hi, I have already posted this query 4-5 days ago but no reply yet so posting 2nd time. Here is the query. Application Used: Visual Basic 6 Database: MySQL 4.0.2 ODBC: MyODBC 3.51.03 I have create a table which has BLOB field in which i want to save a bitmap file. To save record i create a AD

Re: Problem with BLOB field

2002-08-08 Thread deep kapasi
--- Egor Egorov <[EMAIL PROTECTED]> wrote: > deep, > Thursday, August 08, 2002, 4:08:22 PM, you wrote: > > dk> It looks like a simple bug but I have spent lots > of > dk> hours try to solved it but not success yet. > > dk> Application: Visual Basic 6.0 > dk> Database used: MySQL 4.0.1 & MySQL 4.