NLS Settings

Kindly help in followings.

1. At Database server side settings are in Balgium. and from client we want output in American(English).

Means, From one client we want the output, in Balgium and from another Client we want the output in American(English).

I have set NLS_LANG and NUMFORMAT etc. parameters at cleint, side but still getting output in Balgium.

for example I want output for some number as 9,99,999.00, but it is showing in Balgium.

2. How to check the clients OS charcter set. is it in registry at

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage\ACP


Thanks

Can u please post the NLS_LANG setting on the client side.Also your client setting should be same as the server setting or should be a super set of the server setting.