localize databases with working searching and ordering?

Hi,
The way I would do this: in a table I have multiple field for different languages, i.e. colorEN, colorDE, colorFR.
The query would be something 

PHP Code:

$query = $this->db->table('colors')
 ->select('color'.$language.' AS color')
    ->orderBy('color'.$language, 'ASC); 


Where $language is the current selected language.
I guess this would also order the colors correctly.