Hi all, my Oracle database is 8.1.6 and it was created in standard US7ASCII and I have just converted it to UTF8. All the data in the server is in english. Now the user must be able to view/add/update the data in spanish or english depending on the requirement from the front end. Do I have to use a middle layer with a user defined data map which does the transition between spanish & english back and forth, or is there an utility in Oracle which would recognise the NLS_LANG in client and change the Text data ( or a 3rd party tool)?
Any help/ideas/link is greatly appreciated. Most of the input data are text areas and it is going to be difficult to establish a data map.

Thanks,
Shiva.