Nuno Canas wrote: > Denver Braughler wrote: > > I think you have to store it the way you want to retrieve it. > If I'm (user) Chinese, I just want to get the data. > The application is (built in Portugal from a poor guy, and the way he/it > stores data) not important to me as user I just want to have what I want. > So, I cannot create someting dependent the way I want but let the > user/customer have it as he wants/needs.
That's incorrect. You just select the NLS for your database at installation time. > How can I, depending of choosen language (from browser, from cnls or > from %Response.Language) sort the things the way I/customer wants. Write a program to do it, just like any other sort. > Of course, this should not be dependent of the way I store. That is untrue for everything else. If I want a case-blind sort, I have to store it that way. Cache' doesn't do it for me on-the-fly. Why should Portuguese be an exception? It's so easy to make an index to sort exactly the way(s) you want. In fact, there are at least three ways to implement it.
