Nilanjan, The database should know that your program (the client) is feeding it UTF8 data. You can make the database know that by setting the NLS_LANG environment variable correctly. Set it for example to "American_America.UTF8".
Brgds, Mark ----- Original Message ----- From: "Nilanjan Das" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, December 15, 2001 6:20 AM Subject: Problem in inserting utf8(or multibyte char) through Perl DBI > Hi Gurus, > > I tried all tricks but still no luck. > > I am trying to do an insert in Oracle database, through Perl DBI. My > data contains multibyte character(utf8). The insert goes fine but the > inserted data loose the control chars. Specially if the data contains > multibyte stuffs, then only one byte is getting inserted. Is there any > way to make DBI compatible with this or should I set anything in Perl > before doing this? > > Please help. > > Thanks, > Nilanjan > >
