Scenario:
A table that has recoreds in every language under the sun in it,
in UTF-8 format,
A column which identifies which language a record is in,
An INT4 column indentifying the items which are stored in
multiple languages.
Examples:
CtryID Country Language
1 Russia US-EN
1 Руссйя RU <russian spelled in Russian, sort of>
I want to pull out groups of records by language and the country, and then
SORT THE RECORDS IN THE LANGUAGE SELECTED.
Is there any way to say which language to ORDER BY in an SQL statement? Is there in the SQL
standard? If not, this is a serious deficiency for global companies.