This discussion is archived
0 Replies Latest reply: Aug 8, 2011 11:26 PM by 839825 RSS

Issue of inserting greek characters into Oracle database using ICAN505

839825 Newbie
Currently Being Moderated
Hi All,

We are currently facing an issue of inserting greek characters into Oracle database using ICAN505.

We receive a file containing greek characters.The values from the file should be inserted into the database.We are reading the file using file OTD with default encoding.
The file can contain english characters too other than greek characters.

The database NLS_CHARACTERSET is AL32UTF8.

When I insert using an insert statement directly ,the values get inserted properly into the DB table.
Inserting the same values using code results in improper characters getting inserted into the table in the database.

Please help....

Thanks in advance !!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points