[Gambas-devel] MySQL component (4.1 changes)

[nigel at ...2...]

Yes, as within postgresql we could test based on conditional database version, but I can't really see the benefit of doing so for this small change.  As for the discussion about different drivers for different versions, currently that is only relevant for sqlite...only because the functions that changed in version 4.1 MySQL are not being used by the mysql driver.

What we probably need is a way of abstracting the driver functions from the initial driver call...something like the way it's done for the database component :-), so that version specific functions could then be loaded.  Looking at the ODBC driver, this will be even more important since functions that are specific to different databases will also need to be deployed. e.g. There is no user management through ODBC so this will have to be done indirectly through the database standard(?) SQL commands.
 
Nigel

> Message date : Feb 15 2005, 11:48 AM
> From : "Benoit Minisini" <gambas at ...1...>
> To : gambas-devel at lists.sourceforge.net
> Copy to : 
> Subject : Re: [Gambas-devel] MySQL component (4.1 changes)
> 
> On Tuesday 15 February 2005 10:07, nigel at ...2... wrote:
> > Benoit,
> >
> > Attached is a patch file for the mysql component; it adds the new system
> > tables added by MySQL 4.1.  No rocket science here :-)
> >
> > Here is a warning :
> > Due to a bug in the 4.1.8 and 4.1.9 MySQL releases where the API
> > mysql_character_set_name() gives back the collation sequence rather than
> > the character set, the database-manager will crash where character
> > conversion is attempted during the update of a field.  The change at the
> > the mysql end is simple in that the mysql file libmysql.c needs to be
> > altered before being compiled, so that csname is returned instead of name. 
> > Hopefully, the guys that release MySQL will soon have this resolved (it was
> > reported in 4.1.8 so should have been ok in 4.1.9 but my check shows that
> > it is not).
> >
> > regards
> >
> > Nigel
> 
> Isn't it possible to do the test only if mysql version is >= 4.1 ?
> 
> It recalls me a talk about having many database drivers for each version, and 
> loading only the good one at database connection.
> 
> Regards,
> 
> -- 
> Benoit Minisini
> mailto:gambas at ...1...
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Gambas-devel mailing list
> Gambas-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-devel
> 

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm