5 Replies Latest reply on Mar 28, 2018 11:19 AM by Wim Bos

version 17.4.0.355 is not using NLS parameters

Mustafa KALAYCI Jan 5, 2018 8:02 AM

Hi,

current sql developer version is: 17.4.0.355

when I get an error, first error message is in Turkish and rest of it is in English (which I was getting all messages in English)

here is my nls parameters:

"hiç veri bulunamadı" means "no data found" in Turkish.

when I checked NLS_SESSION_PARAMETERS for NLS_LANGUAGE, it is Turkish (even if it is not set in the properties):

with same parameters, it is in English in 17.3:

when I checked nls_session_parameters in this version 17.3:

this is not something big of course but really disturbing, even if it is in my own language(Turkish) I don't understand the error messages sometimes

thanks.

1. Re: version 17.4.0.355 is not using NLS parameters

Mustafa KALAYCI Jan 5, 2018 8:03 AM (in response to Mustafa KALAYCI)

you might say to change, NLS_SORT too and I did but result is the same.
Like Show 0 Likes(0)

Actions
2. Re: version 17.4.0.355 is not using NLS parameters

Oyvind Isene Jan 5, 2018 11:33 AM (in response to Mustafa KALAYCI)

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).

AddVMOption -Duser.language=en

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.
Like Show 1 Likes(1)

Actions
3. Re: version 17.4.0.355 is not using NLS parameters

Mustafa KALAYCI Jan 5, 2018 12:19 PM (in response to Oyvind Isene)

Greetings Oyvind

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.
Like Show 0 Likes(0)

Actions
4. Re: version 17.4.0.355 is not using NLS parameters

Oyvind Isene Jan 5, 2018 12:40 PM (in response to Mustafa KALAYCI)

Thank you, glad it worked. Since this is Java locale settings you can set various of them to get it the way you want.
1 person found this helpful
Like Show 1 Likes(1)

Actions
5. Re: version 17.4.0.355 is not using NLS parameters

Wim Bos Mar 28, 2018 11:19 AM (in response to Mustafa KALAYCI)
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
Like Show 0 Likes(0)

Actions

Go to original post