RE: [toad] how to create Euro sy mbol â,¬ into a O racle table via using TOAD
Thank you very much.
I was able to change the font to COURIER NEW.
I do see the right symbol in my sql statement (in toad editor) if I copy paste the symbol from word.
However, if I try “Num Lock on, ALT 0128”, it gives me a question mark in toad editor still.
Go to OPTIONSèEDITOR/BEHAVIOUR
In Toad 9.7 you see this
Click on the triple dot button next to PL/SQL in LANGUAGES
And you should see this
Now you can play. In the above you see a button labelled CUSTOM FONT. You may see something else. Change it to CORIER NEW.
Then do the APPLY and OK on each screen.
Toad is not at the stage where you must know the OPTIONS dialogue.
ALT 0128 (with numlock on) in toad editor gives me a question mark (?) in my Toad for Oracle 9.5.
Where do you change to COURIER NEW? I used View->Toad Options->Editor->Display->Button Text…, but it did not help.
Yay! Glad you were able to figure it out!
Rich -- [TeamT]
Disclaimer: My workload is interrupting my online Christmas shopping today.
> Everything is OK. I checked further and I noticed my EDITOR font wasCOURIER
> instead of COURIER NEW.going
> Both ALT-0128 (with numlock on) and copy/pasting from word gave me a BLACK
> bar before changing the font and both give me the correct symbol after
> to COURIER NEW. I lied when I said one worked and the other did not.
>> I have used SQL Developer & DBConsole as well ; I assume none of them need any NLS params to be set.
NLS params apply to any/all applications/sessions.
Thanks for your time, Norm & Rich.
I have used SQL Developer & DBConsole as well ; I assume none of them need any NLS params to be set.
I assume, this could have something to do with the export from the Telnet session ( possible incorrect NLS_LANG Settings) ; originally when it was moved from a non-unicode to a unicode 220.127.116.11 and later on to a 18.104.22.168 DB.