>
> > 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 colla
- 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 versio
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