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
Check https://www.experts-exchange.com/questions/20977420/Storing-Displaying-EURO-Symbol-in-Oracle-9i-and-onwards.html
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.
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.
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....
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.