MySQL

query problem

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2005

Posts: 1

Reputation: Morgoth is an unknown quantity at this point

Solved Threads: 0

Morgoth

Offline

Newbie Poster

query problem

Mar 18th, 2005

i'm having a problem with my SQL query. i'm trying to create another column with values based on the values of the other columns and call it sTitle. Every time i try to execute my SQL statement it brings back this error:

Illegal mix of collations for operation 'concat' Error No. 1271

I can't see anything wrong with my syntax but then again i'm kinda new to this. Here's my SQL:

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
SELECT CONCAT(rgMake,' ',IF(rgModel='ST','',CONCAT(rgModel,' ')),IF(rgWheels='2','Two','Single'),' Wheel Roll Grinder   ',ROUND(inDiaCenter*25.4,0),IFNULL(CONCAT('/',ROUND(inDiaMax*25.4,0)),''),' mm Dia.   ',ROUND(inFace*25.4,0),' mm Roll Face') AS sTitle
FROM tblMachine
WHERE rgBecameAvailable IS NOT NULL
ORDER BY rgWheels, ROUND(inDiaCenter*25.4,0), ROUND(inFace*25.4,0)
SELECT CONCAT(rgMake,' ',IF(rgModel='ST','',CONCAT(rgModel,' ')),IF(rgWheels='2','Two','Single'),' Wheel Roll Grinder   ',ROUND(inDiaCenter*25.4,0),IFNULL(CONCAT('/',ROUND(inDiaMax*25.4,0)),''),' mm Dia.   ',ROUND(inFace*25.4,0),' mm Roll Face') AS sTitle
FROM tblMachine
WHERE rgBecameAvailable IS NOT NULL
ORDER BY rgWheels, ROUND(inDiaCenter*25.4,0), ROUND(inFace*25.4,0)