National Lang Support

I've been bragging about to the "co-workers" how Internet can really help someone in a pinch. Now I get to prove it.

Here's the problem:

	Trying to get sqlldr to load data with a ‰ (e accent)
	into the database such that I can then go into sqlplus
	and select the data and see the e accent.

Clues:
	Using Oracle 7 on a HP.  French keyboard :-(

	Once the small table is selected, the data that
	had the e accent character it, is returned as an "i" which
	is the ascii of the e accent chacter minus 128.

	Told Oracle Server to use the NLS_LANG = FRENCH_CANADIAN.WE8DEC
	character set to no avails.  In addition set the NLS_LANG env var
	in shell so that sqlldr and sqlplus know they are to use french.
	Messages for both utilities are then in French but still have the
	character set problem.

	Can "INSERT" data into the table using sqlplus and then
	select the data and "see" the e accent in the selected rows!

What am I missing? Would appreciate any insight or help!

John Dennis Received on Tue Feb 22 1994 - 16:35:46 CET