Friday, March 13, 2009

How to change the language of SQL Developer's user interface?

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

Yesterday i upgraded SQL Developer from version 1.5.1 to 1.5.4 and when i opened it, i noticed that the user interface was automagically showing up in Italian.
I say automagically because i am italian indeed, but the operating system on this particular machine is localized in mexican-spanish, so i wonder if SQL Developer was spying my conversations... ;-)

While i appreciate the globalization efforts, i feel much better having certain programs with an English user interface for the simple reason that when i need to communicate with someone else who doesn't speak Italian, i can talk about menu entries, settings, button names using a commonly understood language and without having to guess what the original entry in English language could be.

How to get rid of this automatic translation then?
I started wandering through the preference menu and either because i am getting old or there are too many settings or this setting can't be changed in the preferences, i failed to find a list available translations.

After a quick OTN search i found a thread where users were reporting some problems when creating new connections and i noticed a workaround where one must add the following two lines to the Sqldeveloper.conf file in bin subdirectory.

AddVMOption -Duser.language=en
AddVMOption -Duser.country=US

I promptly tried it out to see if that could solve my problem and bingo!

I don't know if this is the only "supported" way of changing the user interface language, but it's certainly working.

Please let me know if there are any other options.


See more articles about SQL Developer.

PS: I encourage everyone interested in this feature to cast their vote in the SQLDeveloper Feature request application: https://apex.oracle.com/pls/apex/f?p=43135:7:0::NO:RP,7:P7_ID:10821

42 comments:

Popovic Stevo said...

I hate when program tries to guess your language, and leaves you with no option to change it...

Thanks for info...

Byte64 said...

I agree Stevo,
imagine if you had to work remotely on a customer's PC, say a chinese or japanese machine, and you can't *easily* change language in the user interface: it would be a nightmare, especially if you had to change some menu option.

Of course the reverse might apply as well, for a chinese or japanese person could be difficult to work on a localized version of SQL Developer.

I hope they come up with some easy-to-find menu option in 1.5.5 where you can pick the preferred language, just in case.

Thanks
Flavio

kAlvaro said...

I'm a native Spanish speaker but I googled here to learn how to change the GUI back into English because I just couldn't understand the Spanish translation.

Apparently, they also used Google to translate it.

Byte64 said...

Alvaro,
as you know latin american spanish varies with the nation, the translator may have opted for the mexican word which sounds odd for the spaniard or the argentinian or viceversa.
Normally i don't like translated software because when you encounter a problem then it's much easier to find a solution if you search for english terms, that's the main reason as to why i prefer to have an english OS and english version of the software.

Saludos,
Flavio

Pedro A said...

Thank you very much Flavio Casetta.

jason said...

Thank you. Google suggested your post at the top of the list with only my 3-keywords "sqldeveloper change ui language". Actually, I'm not familiar with the translated terms. Your tip saved my time and it was very helpful for me. thanks~!

amitnema said...

Thank you very much sir...
I digged the whole sqldeveloper & google to explore this option...

thanks again for your great help.

god bless you

Regards,
Amit

birukou said...

Thank you! Worked for me too! I am Belarusian, using English in Italy, so spying over conversation wouldn't work;) I especially was surprised by Italian since I followed all steps for download in English

Anonymous said...

This works perfectly ! I was fighting against this SQL Developer since I upgraded.
Thanks again !! I now have the program in English again and no longer in French.

Anonymous said...

Thanks a lot for this tips. I was quite disapointed with the french interface. English settings has become really more familiar :-).

edilay said...

hi!
I almost took my eye out with this XD.
I use it in versión Version 2.1.1.64 but the file for add the lines is ide\bin\ide.conf.

I'm native spanish too and consider so freak see the Oracle messages in spanish.

thanks a lot Flavio.

Gianfranco said...

Ciao Flavio,

I was having the same issue then, googling, I found this post.

Actually I have the same application language setting (eng) for the same reason.

I'm working on SQL Developer 2.1.1 so I had to guess where the .conf is.
I found it, changed it and wohooo! :)

Of course only at the end I read the above edilay comment!

Thanks a lot for your tip!

Gianfranco

Anonymous said...

i want to change the language of caption of my oracle form from english to french.
how it is possible

Byte64 said...

I don't have a clue, I'm sorry.

Flavio

Anonymous said...

thanks for your reply...but clearify me that it is feasible or not?

Byte64 said...

I don' know, what do you mean exactly by "the caption of my oracle form"?

Anonymous said...

Hi Friend,
Thanks a lot for your post. I searched language setting for SQL Developer, and simply clicked on the first link (yours url). The explanation is so simple to understand and solved my problem in a minute. I am English speaking guy and working on Terminal of Client at Germany. Again its great help.

Thanks
Patel

Kakka said...

Just tried it today, with SQL Developer version 3.0 and works great.
Thanks ;)

Giordano said...

Just tried it today with SQL dev version 3.0 and it works great!
Thanks for the hint (even if unfortunately it means that the un-friendly user experience is still there in the latest version as well..)

pflop said...

Thanks for the tip, very useful.

OracleNewbie said...

Thank you so much for the post - your solution worked for me (SQL Developer 3.0)! The non-english interface was sooo annoying :[

Aravinth Kannan said...

Hi thanks it resolved for SQLDeveloper 3.0

Warren Chang said...

thank you so much. I am so happy to see "English" interface

achim said...

I'm using SQL developer 2.1.1 with a German OS (Win XP). This is not a matter of choice, my employer determines what language the OS uses and WinXP is not an OS for easily changing languages anyway.

I checked the /bin subdirectory of my SQL dev installation and found an ide.conf but not sqldeveloper.conf. None-the-less ide.conf does contain several AddVMOption statements so I made the change as specified. No joy! It hasn't worked. That might be because I don't have the necessary language pack installed.

Anonymous said...

Thank you! it works for me on V3.0.

Frank from Montreal

Anonymous said...

Many many thanks,
Manuel from Spain

Anonymous said...

three years have been passed and still no preference option has been still added to change interface language quickly :-(

Still googleing id required to solve this :-(

Thanks for the info,
Alfonso

Byte64 said...

I encourage everyone interested in this feature to cast their vote in the SQLDeveloper Feature request application:
https://apex.oracle.com/pls/apex/f?p=43135:7:0::NO:RP,7:P7_ID:10821

ജിം said...

Thank You! It solved my problem.

Massimo said...

Thanks, it worked great.

Grazie!

Teste said...

Thanks, it worked great

Anonymous said...

Thanks a lot. It worked .. bingo!!!!!

Anonymous said...

thanks a lot!

CGabat said...

Grazie mille!!!

I am still using a laptop ho comprato a Milano. It has its original Windows XP-Italian Home OS, since 2005.

It is no wonder that SQLDeveloper comes with Italian flavor.

Now, I am happy to have the English UI.

Bravo, Flavio!

Ângelo L. Mazer said...

Very great. It's a relatively old topic but still very usefull. I'm from Brazil and changed the software language to spanish using this solution.
Thanks for sharing!

Anonymous said...

Thanks Flavio. You solved my problem!

Anonymous said...

Oh - am I the only one, where it does NOT work ...

Henning said...

4 years later and this posting is still the top Google hit for "oracle sql developer language". Thank you, very helpful!

Over the SQL Developer versions however, the path of the sqldeveloper.conf has slightly changed; it's now at $installdir/sqldeveloper/bin

München said...

Even into spanish with "idioma sql developer" is the first a few months later!!!!

maykon rodrigues said...

Thank you, In english is better.

Anonymous said...

Thank you. Very useful for me. Greetings from Spain.

Marco Oreste Pogliaghi said...

Hi Flavio just to thank you: I was searching exactly this information.
marco

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles