Friday, 30 October 2015

Oracle SQL Developer - How to change the language


SQL Developer is multi-language by default, and this possibility can be used in a few different ways: a) through Options menu in SQL Developer;
b) changing Language Preferences in Control Panel;
c) changing sqldeveloper.conf file;
d) changing ide.conf file;
e) adding language parameter in the shorcut on your desktop;

My favorite is last possibility, but let's go to see all of them:

a) First possibility is changing the application settings: Tools => Preferences => Database => NLS:


b) Application settings in SQL Developer are inherited from OS Language settings, so you can change them there (Windows): Control Panel => Region and Language:

 

c) Sql Developer config file (sqldeveloper.conf) ist located in \sqldeveloper\bin directory. You need to set user.language and user.country properties (picture shows support for german language) in a config file:

AddVMOption  -Duser.language=de
AddVMOption  -Duser.country=DE


d) You can also set ide.conf file (\sqldeveloper\ide\bin folder), just adding JVM Option
AddVMOption -Duser.language=en in a conf file:



e) My favorite variante is using shortcuts. On this way I can switch my developers environment in a moment - I just need to have proper defined shortcuts on my desktop. All needed is to add --AddVMOption=-Duser.language=de in Target field of Shortcut property:


Supported languages are:
- English = en
- German = de
- French = fr
- Italian = it
- Spanish = es
- Japanese = ja
- Korean = ko

If you  want to exclude some language (offered are and portuguese and chinese, but I found they are not working) from support, you need to change oracle.translated.locales from ide.boot file (located in \ide\bin folder).

Initialy value is: oracle.translated.locales = de,es,fr,it,ja,ko,pt_BR,zh_CN,zh_TW (english is default). If you, for example, wish to remove support for french, new value in ide.boot file were oracle.translated.locales = de,es,it,ja,ko,pt_BR,zh_CN,zh_TW.




No comments:

Post a Comment