Link to home
Start Free TrialLog in
Avatar of andym107
andym107

asked on

How do you dislpay the Euro (€) symbol is Oracle's GUI sqlplus tool.

Has anyone discovered a method for displaying the Euro (€) symbol when selected back from a table in Oracle's GUI version of sqlplus? This would appear to be related to the characterset that the tool uses to display reults

Avatar of Pierrick LOUBIER
Pierrick LOUBIER
Flag of France image

From http://www.oracle.com/technology/tech/sql_plus/htdocs/faq101.html#A4912

How do I display the Euro symbol ("€") in SQL*Plus?
To check if the current font contains the Euro sign, enter the Euro sign's decimal number equivalent in SQL*Plus, Alt+0128. If it appears correctly, the chosen font contains the Euro sign, otherwise you need to try another font.

You can use the Windows Character Map utility to view the characters available in a font. Character Map also shows the decimal number equivalent for extended ASCII characters. You access the Character Map utility by selecting Start, Programs, Accessories and then clicking Character Map.

Avatar of andym107
andym107

ASKER

Thanks - I'm using Arial which contains the euro.  I populate a temporary table thus;

insert into <table name> select chr(14844588) from dual;
insert into <table name> select chr(128) from dual;

I I dun up oracle programs > oracle > sqlplus

select * from <table name>

Unfortunately, no euro is displayed.  I can do it through unix and DOS.  Howewver....
ASKER CERTIFIED SOLUTION
Avatar of JPScandariato
JPScandariato

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of earth man2
earth man2
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial