Toad World® Forums

how to create Euro symbol € into a Oracle table via using TOAD


#1

Could you please tell me how to create Euro symbol € into a Oracle table via using TOAD?

Toad for Oracle version: 9.5

Oracle Database version: 10.2.0.3.0


#2

Hi!

€-Euro sign!

In SQL:
select chr(128) from dual;

From keyboard:
left Alt+0128

Hope this helps
Damir Vadas


#3

My belief is that you’re going to want to use TOAD 10 - which supports Unicode (i.e. more than just ASCII chars).

But there are others who use prior versions - but you have to set certain Oracle client NLS parameters and Windows region choices. So I’ll let someone on the right side of the pond answer :slight_smile:


#4

first, ypur database character set must support it. then, to ensure proper compatibility, you need to ensure your client NLS_LANG matches your database character set. And ideally, as Bert mentioned, upgrade to Toad 10 to get full proper support. Otherwise the rest are only half measures.



#5

The character set of course has to support it.
Most common character sets that do are UTF8, WE8ISO8859P15 and WE8MSWIN1252.

When you use WE8IS8859P15 you can use chr(164) to insert it into the
database.
If your character set is WE8MSWIN1252 use chr(128).
When using UTF8 you should use chr(14844588).

HTH

regards,
Peter

Damir Vadas schreef:

Hi!

€-Euro sign!

In SQL:
select chr(128) from dual;

From keyboard:
left Alt+0128

Hope this helps
Damir Vadas
http://damir-vadas.blogspot.com


#6

And, one more thing, the font you use to display the results grind, for
example, must be able to display a Euro character as well.

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


#7

for those who transport via TGV to London…will there be a friendly banker at
London Terminus to exchange Euros for pounds
?

Martin Gainty
The inherent vice of capitalism is the unequal sharing of blessings; the
inherent virtue of socialism is the equal sharing of miseries - Winston
Churchill


Please do not alter/modify or disrupt this transmission. Thank You


#8

But do it in a word document and cut paste into a line in a toad editor or into
a column in SB if you don’t want to use the CHR() function because the
ALT+numeric kepad values will move around in rows in SB and get previous SQL
statement in Editor.
image001.jpeg


#9

Thanks. See response inline.
image001.jpeg


#10

Thanks. See response inline.
image001.jpeg


#11

Karen,

You can use ALT+0128 in TOAD editor (at least I can) when you enable
NumLock.
That way you won’t get the SQL history in your screen.

regards,
Peter

Karen Chu schreef:

Thanks. See response inline.

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] *On Behalf
Of *Erwin Rollauer
Sent: Monday, November 30, 2009 7:59 AM
To: toad@yahoogroups.com
Subject: RE: [toad] how to create Euro symbol € into a Oracle table
via using TOAD

But do it in a word document and cut paste into a line in a toad editor

This does not work for me.

or into a column in SB if you don’t want to use the CHR() function
because the ALT+numeric kepad values will move around in rows in SB
and get previous SQL statement in Editor.

If I past it in the data in SB it works. But I am interested to know
how it can work in toad editor if possible.

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] *On Behalf
Of *Damir Vadas
Sent: November 27, 2009 10:53 PM
To: toad@yahoogroups.com
Subject: Re: [toad] how to create Euro symbol € into a Oracle table
via using TOAD

Hi!

€-Euro sign!

In SQL:
select chr(128) from dual;

From keyboard:
left Alt+0128

Hope this helps
Damir Vadas
http://damir-vadas.blogspot.com


#12

I hadn’t tried it with NUMLOCK on. When I do it theoretically works.

Since I have Toad 9.7 I presume that when I enter ALT+0128 and get a black bar it is normal behaviour. I further presume I will have to wait until I upgrade to Toad 10.? for ALT+0128 to work.


#13

Hey Erwin,

I hadn’t tried it with NUMLOCK on. When I do it theoretically works.

It’s a Windows thing. You must use the digits on the keypad (the ones above
the letter keys will not work for this), and the easiest way to do that is
by having NumLock on.

Since I have Toad 9.7 I presume that when I enter ALT+0128 and get a black
bar it is normal behaviour. I further presume I will have to wait until I
upgrade to Toad 10.? for ALT+0128 to work.

If I hadn’t just received my new laptop, I could test that for you, but I
could have sworn I did that in 9.7 as well. Are you sure your MOE font is
the same in 9.7 as you’re using in 10?

Rich – [TeamT]

Disclaimer: I do not sparkle.


#14

I used the numeric keypad with numlock on. I only tested in 9.7. I do not yet have 10.? Installed.

I am able to copy and paste a Euro symbol from word into a Toad editor screen but when I use Alt-0128 I get the bold vertical bar (rectangle).


#15

Hey Erwin,

I used the numeric keypad with numlock on. I only tested in 9.7. I do not
yet have 10.? Installed.

I am able to copy and paste a Euro symbol from word into a Toad editor
screen but when I use Alt-0128 I get the bold vertical bar (rectangle).

Try inserting the ALT-0128 char as well as the pasted Euro between the
quotes in this query:

SELECT value, DUMP(’’), DUMP(’’)
FROM v$nls_parameters
WHERE parameter = ‘NLS_CHARACTERSET’;

Of course, there will be a ton of translation done by Oracle in this, but
I’m curious…

Rich – [TeamT]

Disclaimer: Contrary to reports, it was sunny here on Friday.


#16

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.


#17

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 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.


#18

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.


#19

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.
image001.jpeg


#20

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.