OraFAQ Forum: Client Tools » char differences between SQL+ and SQL developer

Home » Other » Client Tools » char differences between SQL+ and SQL developer

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

char differences between SQL+ and SQL developer [message #596307]

Fri, 20 September 2013 03:17

amauri
Messages: 18
Registered: May 2013
Location: Italy

Junior Member

Hi,

we have an issue on a server, where if we insert a value containing foreign characters from SQL+ we see it screwed up from SQLdev, whereas if we do the same insert from SQLdev it's then screwed up in SQL+.
All operations are performed on the DB server itself, SQLdev connection type is TNS and the entry being used is the same as the one used by SQL+.
We checked v$nls_parameters and the values contained there are the same from both SQL+ and SQLdev.
any ideas?

Alberto

Report message to a moderator

Re: char differences between SQL+ and SQL developer [message #596309 is a reply to message #596307]

Fri, 20 September 2013 03:24

dariyoosh
Messages: 538
Registered: March 2009
Location: France

Senior Member

Hi,

Well, just saying "we see it screwed up" doesn't give much information about the problem, but maybe the same (or similar) question has already been answered:

http://www.orafaq.com/forum/mv/msg/189560/596260/#msg_596260

Regards,
Dariyoosh

Report message to a moderator

Re: char differences between SQL+ and SQL developer [message #596310 is a reply to message #596307]

Fri, 20 September 2013 03:24

Michel Cadot
Messages: 68510
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

NLS_LANG (especially NLS_CHARACTERSET) are not the same ones; this is something you cannot check with v$nls_parameter.

Report message to a moderator

Re: char differences between SQL+ and SQL developer [message #596311 is a reply to message #596310]

Fri, 20 September 2013 03:27

amauri
Messages: 18
Registered: May 2013
Location: Italy

Junior Member

Hi Michel, where do I check NLS_LANG settings in SQL+ and SQL dev.?

Report message to a moderator

Re: char differences between SQL+ and SQL developer [message #596312 is a reply to message #596311]

Fri, 20 September 2013 03:32

dariyoosh
Messages: 538
Registered: March 2009
Location: France

Senior Member

NLS_LANG is normally defined as an OS level environment variable.

Regards,
Dariyoosh

Report message to a moderator

Re: char differences between SQL+ and SQL developer [message #596313 is a reply to message #596311]

Fri, 20 September 2013 03:32

amauri
Messages: 18
Registered: May 2013
Location: Italy

Junior Member

Sample
insert in SQL+:
insert into MyTable(MyWord)values('federaçao');
select from SQL+:
select MyWord from MyTable;
MyWord
------------
federaçao
select from SQL developer:
select MyWord from MyTable;
MyWord
------------
federa│ao

Report message to a moderator

Re: char differences between SQL+ and SQL developer [message #596314 is a reply to message #596313]

Fri, 20 September 2013 03:35

amauri
Messages: 18
Registered: May 2013
Location: Italy

Junior Member

Hi dariyoosh,

the server does not have it set in the environment, but it's set in the registry.

Report message to a moderator

Re: char differences between SQL+ and SQL developer [message #596315 is a reply to message #596313]

Fri, 20 September 2013 03:38

dariyoosh
Messages: 538
Registered: March 2009
Location: France

Senior Member

So the 'ç' character seems to be the source of the problem, that's why you should check your nls_lang and the characterset on the server.

Quote:

the server does not have it set in the environment, but it's set in the registry

Have a look at this:

Configuring Locale and Character Sets Using NLS_LANG

What is the value of NLS_LANG that you have defined for your OS (Windows I may assume?)

Regards,
Dariyoosh

[Updated on: Fri, 20 September 2013 03:39]

Report message to a moderator

Previous Topic:	how to run all sql scripts from one script
Next Topic:	ORA-12504, TNS:listener was not given the SID in CONNECT_DATA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 01 11:02:50 CDT 2023