you might say to change, NLS_SORT too and I did but result is the same.
Greetings from Norway; I had the same "problems"
It looks like it picks up the user.language from JVM, you can check this from Help -> About -> Properties and write lang in the search field. You can't change it there. What worked for me was to add this at the end of file sqldeveloper.conf in the bin folder (sqldeveloper\sqldeveloper\bin).
That file will be replaced after next upgrade, so it is best to find the product.conf file that gets migrated when you install a new version. I found mine under C:\Users\luser\AppData\Roaming\sqldeveloper\17.4.0 You can verify in Properties that the change works. I tested both OK.
thanks for the solution and it worked. I checked about -> properties and there were those:
user.language => en
user.language.format => tr
I changed the file as you mentioned and now "user.language.format" disappeared and it is all English now. interesting this didn't happen on previous releases.
thank you very much Oyvind.
1 person found this helpful
Thank you, glad it worked. Since this is Java locale settings you can set various of them to get it the way you want.
This is a bug, right? 'NLS_LANG' setting in SQL developer is ignored/overruled by language setting at operating system level.
Never experienced this issue before with SQL developer, untill I got a new laptop at work
Found an alternative elegant 'workaround' solution:
- Change 'Format' value in 'Region and Language' settings (Control Panel > Clock, Language, and Region > Region and Language > Change the date, time or number format) [I've updated value 'Dutch (Belgium)' into 'English (Ireland)' to at least have European settings auto-defaulted on my Windows 7 laptop]
- Restart SQL developer