Link to home
Start Free TrialLog in
Avatar of chip14
chip14

asked on

Nvarchar2 Datatype problem in an insert statement.

How could I insert a value on a field whose data type is NVarchar2. I tried the normal insert but an error appeared.
Here is the sample command that I used:
insert into tablename values ('100022','hjsl')
The error is character set mismatch.

The reason that i set my field data type to NVarchar2 is because I want the field to accept unicode characters.
Avatar of chip14
chip14

ASKER

Do you know any command to retrieve the National Characterset of my database?
ASKER CERTIFIED SOLUTION
Avatar of Bigfam5
Bigfam5

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial