ok so the colum I want to sort on has integer values 2,4,5,1,2, etc.
These represent types, such as apple, oranges and so on. The sort of the column is expected to be alphabetical.
Example:
Apple in german is apfel and orange is apfelsine, pomme , orange is orang�(I think).
So displayed and sorted in german the order is apfel , apfelsine.
In french it is orang�, pomme. So a sort in french would put orange before apple.
Assume I have thousands of records, even hundreds of thousands of records and I want the database to do the sort for me. To sort in my
java application would require me to read the entire resultset which would get VERY memory expensive.
My application uses integer types in the colum since I support multiple languages at the same time. So I can't just have the german or french
word in the column.
That's where I wonder if I could put in tables to hold language strings in the database and another lookup table to find the language table name at query time.