| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Fredrick Bartlett | Date: | October 29 2004 4:08pm |
| Subject: | Extract MySQL Version | ||
| View as plain text | |||
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?
| Thread | ||
|---|---|---|
| • mysql 3.23 store large data | Jerry Swanson | 27 Oct |
| • Re: mysql 3.23 store large data | Gleb Paharenko | 27 Oct |
| • Re: mysql 3.23 store large data | Jerry Swanson | 29 Oct |
| • Re: mysql 3.23 store large data | Friedhelm Betz | 29 Oct |
| • Extract MySQL Version | Fredrick Bartlett | 29 Oct |
| • Re: Extract MySQL Version | Rhino | 29 Oct |
| • Re: Extract MySQL Version | Martijn Tonies | 29 Oct |