oracle table insert: french accent

From: Simonz <pssoft7_at_hotmail.com>
Date: 21 Jul 2003 20:24:58 -0700
Message-ID: <3a316a01.0307211924.2f13bed2@posting.google.com>

Hi, there.

I have read many postings about character sets and database support for multibyte.
I came to conclusion that by setting database's character set to UTF8 or WE8ISO8859P1 I would be able to INSERT into my tables, data with french accents.
I set my environment variable (UNIX) LANG=fr and launch SQL*Plus, connect to Oracle database and tried this:

• cut ----- SQL> CREATE TABLE try_one (my_name nvarchar2(10));

Table created.

SQL> INSERT INTO try_one VALUES ('vhicule'); INSERT INTO try_one VALUES ('vhicule')

                            *

ERROR at line 1:
ORA-12704: character set mismatch

• cut -----

PS: the 'vhicule' is actually 'vehicule' with french e (with an accent).

I have no idea of what wrong with this. could anybody please give me some clue or hints? I have searched web sites using googles in either web sites or newsgroups with no clues.

Thanks in advance.

Simonz Received on Mon Jul 21 2003 - 22:24:58 CDT