SQL*Plus (MOSC)

MOSC Banner

Wrong display of accentuation in SQL*Plus

edited Mar 1, 2013 1:10AM in SQL*Plus (MOSC) 4 commentsAnswered
 Hi guys,
When I fetch rows using SQL*Plus I get wrong characters displayed.
If I use a visual tool such as SQL Developer, there's no problem.

This is probably a MSDOS encode configuration, but I can't find a solution for this. Maybe some of you had a similar experience with this and could be able to help me, or give a suggestion.

Let's use this table as example:

create table table1 (field1 varchar2(10));
insert into table1 values ('aãâeêóò');
insert into table1 values ('gênese');
insert into table1 values ('conceição');
insert into table1 values ('fácil');
commit;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center