[Gambas-user] Wanted String got Blob Instead gambas 1.9.23

[Lorenzo Tejera]

Here is the table definition:

CREATE TABLE `tbclientes` (
  `ID` int(16) NOT NULL auto_increment,
  `Nombre` varchar(200) NOT NULL default '',
  `NIF` varchar(50) NOT NULL default '',
  `Direccion` mediumtext NOT NULL,
  `Telefono1` varchar(50) NOT NULL default '',
  `Telefono2` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM;


  `Direccion` mediumtext NOT NULL,

In Database Manager not appear any data in this field??

Could be a problem with new mysql 5.0 server?

On Mie, Enero 11, 2006 00:44, Benoit Minisini wrote:
> 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
>
>