Re: Extract MySQL Version

2004-10-29 Thread Rhino 

- 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]

Re: Extract MySQL Version

2004-10-29 Thread Martijn Tonies 


  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]