Search This Blog

Wednesday, May 02, 2007

How to display euro symbols on windows and DOS sql*plus windows

create table aa (a varchar2(20));

insert into aa values ('');

From sqlplusw window it will show the euro symbol
select * from aa;

come to DOS prompt and invoke sqlplus
select * from aa;
will show some junk values , now check the active code page
chcp
Active code page: 437

Change the Active code page to 1252 and check from sql*plus
chcp 1252
Active code page: 1252

This will show the correct euro symbol.

No comments: