Home » SQL & PL/SQL » SQL & PL/SQL » How can I insert into Oracle DB not standard character like ''Ç,Ü" ? (PLSQLDev)
How can I insert into Oracle DB not standard character like ''Ç,Ü" ? [message #355258] Thu, 23 October 2008 05:24 Go to next message
waseem83
Messages: 2
Registered: October 2008
Junior Member
want to insert a record into a table hotel:
i use this SQL :
insert into hotel(name) values('AKKO BUTIK OTEL TURIZ');
but it is inserted like ''AKKO? BUTIK OTEL TURIZ'' ?!
how can i fix that?

I use PLSQL Developer

thanks,
Re: How can I insert into Oracle DB not standard character like ''Ç,Ü" ? [message #355259 is a reply to message #355258] Thu, 23 October 2008 05:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use
1/ Correct database character set
2/ Correct client character set
3/ Correct NLS_LANG setting

Regards
Michel
Re: How can I insert into Oracle DB not standard character like ''Ç,Ü" ? [message #355262 is a reply to message #355259] Thu, 23 October 2008 05:27 Go to previous message
waseem83
Messages: 2
Registered: October 2008
Junior Member
Michel Cadot wrote on Thu, 23 October 2008 05:25
Use
1/ Correct database character set
2/ Correct client character set
3/ Correct NLS_LANG setting



1. I use nvarchar

but how about the 2 others point , how can i set them?
Previous Topic: find names form the table
Next Topic: How to extract excel file into oracle database
Goto Forum:
  


Current Time: Sun Dec 11 06:09:24 CST 2016

Total time taken to generate the page: 0.26154 seconds