Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

inserting multi lingual data

Status
Not open for further replies.
rk68

rk68

Programmer
Jul 15, 2003
171
IN
Hi,
I have table with a field with type NVARCHAR2.
While trying to insert data into this field from PL/SQL developer, it store the value as inverted question mark (?).
If I copy paste the multilingual data in the field, it store as it is & when I query, I can view the data. Its while inserting, I'm facing this issue.

Oracle is 11g
NLS_NCHAR_CHARACTERSET = AL16UTF16
NLS_CHARACTERSET = WE8MSWIN1252
NLS_LANGUAGE = ENGLISH

What could be the issue & where am I going wrong.

Thanks in advance,
RAJ
 
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
433
carp
carp
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
168
TheLazyPig
TheLazyPig
TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
369
carp
carp
Detonah
  • Locked
  • Question
Micros Res 3700 - Cashier Report Displaying Multiple Days Together
Replies
0
Views
352
Detonah
Detonah
Andrzejek
  • Locked
  • Question
Insert multiple records 1
Replies
9
Views
468
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top