I need to setup a DB which supports multilingual data entry and viewing.
I have installed oracle 8i on sun solaris 2.6 o/s. During installation, I selected UTF8 as the database character set and the national character set. The installation went fine.
After installation, I created a table called "test" with two columns in it, "code" and "description". I selected the datatype for both the columns as NVARCHAR2.
After that, I created a DB connection to the new DB using Microsoft Query and opened the "test" table.
I tried inserting english characters in it and I got a character type mismatch error. This error message also appears when I used sqlplus to input data to the "test" table. I am using windows NT4.0 as the client.
Do I have to change the character set of my o/s so that I can insert data to the "test" table I have created?
Are there any step by step solutions available to assist me in this matter? My objective here is to be able to insert a mixture of chinese and english characters to the "description" column of the "test" table. In future, I would also like to insert other national characters such as spanish and german. Thanks.