Home » SQL & PL/SQL » Client Tools » PL SQL Developer Program Help (PL SQL Developer 7.0.3)
PL SQL Developer Program Help [message #449384] Mon, 29 March 2010 06:20 Go to next message
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
Re: PL SQL Developer Program Help [message #449386 is a reply to message #449384] Mon, 29 March 2010 06:28 Go to previous messageGo to next message
Michel Cadot
Messages: 66644
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
Re: PL SQL Developer Program Help [message #449399 is a reply to message #449386] Mon, 29 March 2010 06:53 Go to previous messageGo to next message
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?
Re: PL SQL Developer Program Help [message #449407 is a reply to message #449399] Mon, 29 March 2010 07:15 Go to previous messageGo to next message
Michel Cadot
Messages: 66644
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 Go to previous messageGo to next message
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.
Re: PL SQL Developer Program Help [message #449576 is a reply to message #449574] Tue, 30 March 2010 10:33 Go to previous messageGo to next message
Michel Cadot
Messages: 66644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Good to know.

Regards
Michel
Re: PL SQL Developer Program Help [message #449606 is a reply to message #449576] Tue, 30 March 2010 19:36 Go to previous message
flisbao
Messages: 3
Registered: March 2010
Location: Brazil
Junior Member
I found out why it was happening.
It was the oracle database language installed on my computer.
Thanks anyway for your help.

Previous Topic: execute a procedure with parameter of object type
Next Topic: TOAD - Execute as Script not available
Goto Forum:
  


Current Time: Mon Oct 21 01:13:22 CDT 2019