Questions:
What is the NLS character set of your database? select * from v$nls_parameters; What is NLS_LANG set to? echo $NLS_LANG Can you insert these special characters by any other means: e.g. sqlplus, sqlloader, import? The problem is likely with your environment and/or database, doesn't sound like a Perl or DBI problem. Jared On Thursday 13 December 2001 05:40, Nilanjan Das wrote: > Hi All, > > I am new to this and need your help. > > I am using perl5.6.1 on HP-UX, I am using the DBI and DBD-Oracle. I am > facing a problem. I have a datafile which has some special character > like the utf8 character string. When I try to parse the file in Perl and > then try to insert it in the database through the DBI interface, the > insert works fine, but the special characters are no more there in the > database. > > Can anyone point me where I am wrong? Do I need do any further > processing. My database is capable of handling NVARCHAR, NCHAR etc. > > From the same perl program, if I load the data through sqlldr, it works > fine. So, I suspect there is something wrong with DBI. > > Can any of you point me that? Will really appreciate your help on this. > > Thanks, > Nilanjan
