If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

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.