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,

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use
1/ Correct database character set
2/ Correct client character set
3/ Correct NLS_LANG setting

Regards
Michel

Report message to a moderator

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?

Report message to a moderator

Previous Topic: find names form the table
Next Topic: How to extract excel file into oracle database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 07 00:30:45 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.