SQL & PL/SQL

Hi

I have created my database to use UTF8 characterset and I have set the NLS_LENGTH_SEMANTICS to 'CHAR'.

How do I insert UTF-8 data into a VARCHAR2 column?

I know I can use SQL Loader to do so, but if I want to use only SQL, how do I write my SQL statements?

Provided I set my NLS_LANG accordingly, can my SQL statement include raw UTF8?

For example,

insert into message_tbl (mydata) values ('日本');

Thanks.

PS. I know there is no UTF8 native support in Windows, but I am working in a Unix environment.