title: Inserting a record in Oracle table with a value in different language
body: <p>I am having problem with inserting a record in Oracle database table.</p>
  
  <p>I have a table with a field name in Spanish “RÃ“TULO”. Just because of having fields, and values with some special characters, I cannot use the following simple insert command. I have also value for that field which has special characters.</p>
  
  <p>I am pretty sure there is some setting in Oracle that allows me to accept different language (Spanish). Can somebody point me URL where I can learn about setting?</p>
  
  <p>INSERT INTO "MyTable" ("RIDCODE" , "RÃ“TULO" ) values ('LVL1', 'Some Value with special characters');</p>
  
  <p>I get the following error
  SQL Error: ORA-01747: invalid user.table.column, table.column, or column specification
  01747. 00000 -  "invalid user.table.column, table.column, or column specification"</p>
  
  <p>*Cause:<br>
  *Action:</p>