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.
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.
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.
Morning all,
Erwin’s instructions change the font used in PL/SQL scripts for certain highlighting effects. It won’t change the fonts used in the editor and/or data grids or script output. To do this, proceed as follows:
Editor Font:
Right click in the editor, choose editing options.
Choose display on the left.
On the right, click the Editor and/or line# buttons.
Choose a font. (I use Verdana 10 point for everything!)
Click OK.
Click Apply.
Editor Printing Font:
Still in the dialogue, select Editor/Printing on the left.
Choose Header…, Footer… or Line Nums… button(s).
Choose a font. (I use Verdana 10 point for everything!)
Click OK.
Click Apply.
Data Grid Font:
Still in the options dialogue, select Data Grids/Visual on the left.
On the right, click the Data…, Header… or Preview Col… button(s).
Choose a font. (I use Verdana 10 point for everything!)
Click OK.
Click Apply.
Script Output Font:
Still in the dialogue, choose Execute/compile on the left.
On the right, click the font… button.
Choose a font. (I’d like to use Verdana 10 point but the options here are restricted!)
Click OK.
Click OK.
There are lots of other fonts that you can set, so if you open the options dialogue, at the bottom is a search box, type font and click the search button. Double click each of the results in turn to go directly to that option.
Now, if you find that you can happily enter a Euro character in the editor - which will only happen if the font supports the Euro - but when you select it from dual you see “blobs” or upside down question marks in the grid, the database character set doesn’t support the Euro.
As Bert mentioned earlier in this thread, you need Toad to be using the correct font, your client to be using the correct characterset/NLS_LANG and also the database to have been created with a Euro supporting character set.
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
And does ALT0128 give you the euro symbol in Word?
Karen Chu schreef:
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.From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] *On Behalf Of
*Erwin Rollauer
Sent: Monday, November 30, 2009 1:53 PM
To: toad@yahoogroups.com
Subject: RE: [toad] how to create Euro symbol â,¬ into a Oracle table
via using TOADGo 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.
From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] *On Behalf Of
*Karen Chu
Sent: November 30, 2009 3:27 PM
To: toad@yahoogroups.com
Subject: RE: [toad] how to create Euro symbol â,¬ into a Oracle table
via using TOADALT 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.From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] *On Behalf Of
*Rich Jesse
Sent: Monday, November 30, 2009 11:31 AM
To: toad@yahoogroups.com
Subject: RE: [toad] how to create Euro symbol â,¬ into a Oracle table
via using TOADYay! 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 was
COURIER
instead of COURIER NEW.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 going
to COURIER NEW. I lied when I said one worked and the other did not.
Hi Karen,
I was able to change the font to COURIER NEW.
Using Erwin's instructions? If so, please see my previous email on the subject. Erwin's instructions only change the fond for a particular part of highlighting a PL/SQL script - you are not running (or typing) a PL/SQL script so the highlighting doesn't come into force.
Of course, it could be that the highlighting (of the GENERAL 'item') for PL/SQL does set the editor font as a side effect, but it isn't the correct way to set the editor/grid/script output/etc fonts.
I do see the right symbol in my sql statement (in toad
editor) if I copy paste the symbol from word.
Hmm, this is confusing...
However, if I try "Num Lock on, ALT 0128", it gives me a
question mark in toad editor still.
I presume you don't have a UK style keyboard? I wonder what happens if you use AltGR and the '4' key (on the top row of keys) - that's how we Europeans enter the Euro directly from the keyboard.
What happens if you :
select 'X',dump('X') from dual;
When you replace the X with ALT+0128 both times? Do you see a Euro in the editor?
When you run the above, what is the resulting output?
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
I changed the font for the DEFAULT. All the other items in the highlighting list use the DEFAULT font Unless there is a CUSTOM font specified for them. I never changed the font for any of the other items so all my items now use the DEFAULT font because of the one change.
I should have made that clear. Sorry.
If you don’t have Office try WordPad or NotePad. Both of those come with Windows and I am able to get the euro sign on both using ALT+0128.
Hi Erwin,
I changed the font for the DEFAULT. All the other items in
the highlighting list use the DEFAULT font Unless there is a
CUSTOM font specified for them. I never changed the font for
any of the other items so all my items now use the DEFAULT
font because of the one change.
True. I was a little concerned as to how the MOE actually decided to use PL/SQL highlighting when a SQL script was in the editor.
I should have made that clear. Sorry.
Not a problem. Toad allows many options and like Unix, lots of ways to achieve the same output!
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Thank you. I like VERDANA but it is a proportional font and for editing I like a fixed point font.
Is there another fixed point font that looks better than courier new.
One more piece of info.
There is a big difference between a Black rectangle and an upside down question mark.
The black rectangle means the code is correct in the database but the client can’t display it because of a font issue.
I sort of confirmed this by entering ALT+01289 in SQL*Plus (version 10.?) and it showed a black rectangle. I presume it is because Oracle in its wisdom chose a bad fixed point font. But if I copy and paste that black rectangle into UltraEdit it then shows as a Euro sign.
The Upside down question mark means Oracle does not want to play. It considers the code entered invalid and replaces it with a upside down question mark.
Hi Erwin,
Thank you. I like VERDANA but it is a proportional font and
for editing I like a fixed point font.
Is there another fixed point font that looks better than courier new.
I'm fond of Verdana myself, but if I need a fixed width font, I use Courier New usually. I'm pretty sure Rich has lots of special fonts that he uses. None of them standard installs on Windows though.
He'll probably chime in when he gets online (or gets a break at work!).
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Norm!
I'm fond of Verdana myself, but if I need a fixed width font, I use Courier
New usually. I'm pretty sure Rich has lots of special fonts that he uses.
None of them standard installs on Windows though.He'll probably chime in when he gets online (or gets a break at work!).
LOL -- dealing with other "fun" things at the moment but can't resist a good
font thread.
I'm picky. Picky, picky, picky. I've searched many a free font and have
always come back to Lucida Console. It's not perfect, but as close to it as
I could get without paying for a font (or, more correctly, a "typeface").
There was an extensive thread here back in April 2009 titled strangely
enough "editor fonts". From my post back then, here's my take on some of
the fonts I tested (emphasis on visible lines/page):
Font Lines Comments
I've been using Lucida Console too for a while and seems like the best all
around font. Thanks Rich!
Disclaimer: T-1116 Days and counting
Are you sure it is not T-1071?? Although T-1116 should be interesting too.
Ed
[TeamT]
And does ALT0128 give you the euro symbol in Word?
It does in Word. But not in Toad editor regardless of the custom font I choose
for PLSQL.
Karen Chu schreef:
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.From: toad@yahoogroups.com [mailto: toad@yahoogroups.com ] *On Behalf Of
*Erwin Rollauer
Sent: Monday, November 30, 2009 1:53 PM
To: toad@yahoogroups.com
Subject: RE: [toad] how to create Euro symbol â,¬ into a Oracle table
via using TOADGo 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.
From: toad@yahoogroups.com [mailto: toad@yahoogroups.com ] *On Behalf Of
*Karen Chu
Sent: November 30, 2009 3:27 PM
To: toad@yahoogroups.com
Subject: RE: [toad] how to create Euro symbol â,¬ into a Oracle table
via using TOADALT 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.From: toad@yahoogroups.com [mailto: toad@yahoogroups.com ] *On Behalf Of
*Rich Jesse
Sent: Monday, November 30, 2009 11:31 AM
To: toad@yahoogroups.com
Subject: RE: [toad] how to create Euro symbol â,¬ into a Oracle table
via using TOADYay! 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 was
COURIER
instead of COURIER NEW.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 going
to COURIER NEW. I lied when I said one worked and the other did not.
What do you have set in View > Options > Editor > Display > Fonts > ‘Editor’
button?
I have Courier New with Western Script.
I do not have “edit button” from View > Options > Editor > Display > Fonts >
But I did change it in Editor->Behavior->PL/SQL->Edit… (see below)
Also, I changed Editor->Display->Fonts-> All above 4 buttons (Line #…, Hex…,
Offset…, Text…) to be COURIER NEW
NumLock on and ALT 0128 gives “?”
I do not have “edit button” from View > Options > Editor > Display > Fonts >
But I did change it in Editor->Behavior->PL/SQL->Edit… (see below)
Also, I changed Editor->Display->Fonts-> All above 4 buttons (Line #..., Hex…,
Offset…, Text…) to be COURIER NEW
NumLock on and ALT 0128 gives “?”
I do not have “edit button” from View > Options > Editor > Display > Fonts >
But I did change it in Editor->Behavior->PL/SQL->Edit… (see below)
Also, I changed Editor->Display->Fonts-> All above 4 buttons (Line #..., Hex…,
Offset…, Text…) to be COURIER NEW
NumLock on and ALT 0128 gives “?”
Weird…what version are you on?
