Using different languages on the same windows client
153067May 18 2004 — edited May 18 2004Hi!
Here is my question:
I have a citrix server with American windows code page 1252. Users from 3 different countries are connecting to this server. They are trying to connect to different database instances with different character set. Polish, Russian and English.
Our application does not support UTF8.
What we do is to create a login script which changes the regional options for users according to their IP addresses. If the user is comming from Poland the regional options is set to polish (The default language is not changed). Then we have a BAT file in which we set the NLS lang to POLISH_POLAND.EE8MSWIN1250 and in the same bat file we start the application.
Now the default code page is not changed and is still set to 1252!
What happens? I think the user will be able to see the right polish characters but can they put in right polish characters into the database through the application? the database character set is Polish_Poland.EE8ISO8859P2 or POLISH_POLAND.EE8MSWIN1250.
Is this correct?
what should I do to achieve what I am trying to do?
As I have understood the right NLS_LANG on the client should be based on the code page and it means that it should be AMERICAN_AMERICA.WE8MSWIN1252 but it can not support the polsih characters?
When you chnage the users regional option does microsoft use the appropriate code page for that language?
Thanks for your help?