No subject

;

TINYBLOB, BLOB, MEDIUMBLOB and LONGBLOB are binary strings whilst TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT are more akin to CLOB.

Nigel


> Message Received: Jan 10 2006, 11:45 PM
> From: "Benoit Minisini" <gambas at ...1...>
> To: gambas-user at lists.sourceforge.net
> Cc: 
> Subject: Re: [Gambas-user] Wanted String got Blob Instead gambas 1.9.23
> 
> On Tuesday 10 January 2006 19:09, Lorenzo Tejera wrote:
> > Errrrrr....
> >
> > Probing the last version, some software who works fine, now said:
> >
> > Wanted String got Blob Instead
> >
> > and my Field is a Mediumtext!!!
> >
> > Mysql server version: 5.0.18-Debian_1-log
> >
> > Any idea Benoit?
> >
> 
> In mySQL (I dislike him more and more), there is no difference between TEXT 
> fields and BLOB fields. So to implement it in the gambas database driver, I 
> decided to use "LONG TEXT".
> 
> It is strange that you tell that your field is a "MEDIUM TEXT". Logically, 
> only "LONG TEXT" are recognized as BLOB by the gambas mysql driver...
> 
> Are you sure that your field is "MEDIUM TEXT" ?
> 
> I can make a mistake of course, as sometimes mySQL identifies the datatype of 
> a field precisely (TINY, MEDIUM, LONG TEXT/BLOB), and sometimes it just tells 
> you that it is a TEXT field, and I have to check the maximum length of the 
> data to know if it is TINY, MEDIUM, or LONG.
> 
> Sorry for that! :-)
> 
> -- 
> Benoit Minisini
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
> 
>