>
> > I use the following to extract the version number. But it throws an
error
> on
> > newer version 5.xx. It works on version 4.0 and below.
> >
> > SELECT SUBSTRING(VERSION(),1,LOCATE("-",VERSION())-1) AS VERSION
> >
> > On version 5.0.1-alpha-nt-log I get an error...
> > Illegal mix of collations
> > (utf8_general_ci,IMPLICIT)and(latin1_SWEEDIH_CI,coercible) for operation
> > 'locate'
> >
> > Is this problem by design?
> >
> Try spelling SWEEDISH correctly and see if that helps.
>
> You left out the second 'S' in 'SWEEDISH_CI' ;-)
How would spelling the error message correctly help with the query?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
