Database Software

Hi all,

I have a .csv file with English words and their Hungarian equivalent - the .csv file is
fine and appears with the correct accents in both LibreOffice Calc and with gedit
and the command line (i.e. $> more my_file.csv) in bash.

==========================
consumption,fogyasztás
consumption,tüdővész
precious,értékes
precious,drága
===========================

I then create an external table
=================================
CREATE TABLE Hungarian_dict
(
Angol VARCHAR2(50),
Magyar VARCHAR2(50)
)
ORGANIZATION EXTERNAL
(
type oracle_loader
default directory MY_FILES
access parameters
(
records delimited by newline
fields terminated by ','
missing field values are null
)
location ('SZOTAR.csv')
)
reject limit unlimited;
============================


The problem is, for example, the word "consumption"
Select * from hungarian_dict where angol = 'consumption';

appears thus (exported from SQL Developer (also gibberish in SQL*Plus).

==========================
pol@pol-laptop:~/Downloads/personal/hungary$ more export.tsv
"ANGOL" "MAGYAR"
"consumption" "fogyasztás"
"consumption" "tüdővész"
pol@pol-laptop:~/Downloads/personal/hungary$
===========================

My question is how do I get Oracle to display the correct settings? Do I have to
reload my table with different NLS_LANG settings? NLS_LANGUAGE in the
database?

===========
SQL> show parameter NLS_LANGUAGE;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_language string AMERICAN
SQL>
===============

at the bash prompt, if I type "locale" the result is
=====================================
en_IE.utf8
=====================================
for everything.

Should I create my table with a different character set and collation for the
Hungarian language field?

TIA,


Paul...