OraFAQ Forum: Client Tools » PL SQL Developer Program Help

Home » Other » Client Tools » PL SQL Developer Program Help (PL SQL Developer 7.0.3)

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

PL SQL Developer Program Help [message #449384]

Mon, 29 March 2010 06:20

flisbao
Messages: 3
Registered: March 2010
Location: Brazil

Junior Member

I dont know why, but my PL SQL Developer keeps changing special character as "ã", or "ç", to "?". And As I use these letters because of my language, I need a way to solve this thing.

Does anyone have an idea of how can I solve this?

Thanks in advance.

Felipe

Report message to a moderator

Re: PL SQL Developer Program Help [message #449386 is a reply to message #449384]

Mon, 29 March 2010 06:28

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

Senior Member
Account Moderator

Either:
- your database character set does not support these characters
- the NLS_LANG of the user that started the instance specifies a character set that does not support these characters
- your NLS_LANG perameter specifies a character set that does not support these characters
- maybe something else between you and the database has not a correct character set

Regards
Michel

Report message to a moderator

Re: PL SQL Developer Program Help [message #449399 is a reply to message #449386]

Mon, 29 March 2010 06:53

flisbao
Messages: 3
Registered: March 2010
Location: Brazil

Junior Member

Hey, thanks for your help. I just installed this program in my machine. But I dont know how to see these parameters that you said.
So how can I see that?

Report message to a moderator

Re: PL SQL Developer Program Help [message #449407 is a reply to message #449399]

Mon, 29 March 2010 07:15

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

Senior Member
Account Moderator

For your client part, search for NLS_LANG in Windows registry.
I don't use PL/SQL Developer so I don't know where it put it (something in HKLM\Software\Oracle I bet).
For the database (if you work connected to it), ask your DBA.

Regards
Michel

[Updated on: Mon, 29 March 2010 07:15]

Report message to a moderator

Re: PL SQL Developer Program Help [message #449574 is a reply to message #449384]

Tue, 30 March 2010 10:31

scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England

Senior Member

Hi,

I think you might need to untick the unicode option in Tools - Preferences - Oracle - options.

The help says

Unicode enabled.
When selected, Unicode data will be fetched as such from the Oracle Server, and displayed as Unicode text. When disabled, Unicode data from the server will be converted to the character set of the Oracle Client, in accordance with the NLS_LANG key of the Oracle Home Registry.

Report message to a moderator