----- Original Message -----
From: "Fredrick Bartlett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 29, 2004 12:08 PM
Subject: Extract MySQL Version
> 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' ;-)
Rhino
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
