Re: Extract MySQL Version - Martijn Tonies - com.mysql.lists.mysql

7 messages in com.mysql.lists.mysqlRe: Extract MySQL Version

From	Sent On	Attachments
Jerry Swanson	27 Oct 2004 09:22
Gleb Paharenko	27 Oct 2004 10:09
Jerry Swanson	29 Oct 2004 07:56
Friedhelm Betz	29 Oct 2004 08:03
Fredrick Bartlett	29 Oct 2004 09:08
Rhino	29 Oct 2004 09:43
Martijn Tonies	29 Oct 2004 09:57

Subject:	Re: Extract MySQL Version
From:	Martijn Tonies (m.to...@upscene.com)
Date:	10/29/2004 09:57:34 AM
List:	com.mysql.lists.mysql

I use the following to extract the version number. But it throws an

error

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,