Yes , It worked. Could you pls tell me whats the difference between adLongVarWChar and adLongVarChar? Does SQLite support Unicode encoding(UTF-8)?
-----Original Message----- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 4:13 PM To: SQLite Subject: [sqlite] Re: Insert chinese characters in SQLite database Kalyani Phadke <kphadke-8X8oebJBdj0/CDIEhCN/twC/[EMAIL PROTECTED]> wrote: > The following query inserts ???? into the database > > Cmd1 .Parameters.Append(Cmd1 .CreateParameter("ipaddress", > adLongVarChar, adParamInput, 50, ipaddress)) Try adLongVarWChar for parameter type. Igor Tandetnik ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------