[Firebird-net-provider] insert chinese character into firebird table

[halim setiyawan]

Hi,

I want to insert chinese character into Firebird 1.5 table, how do i do that ? 
below is my code:

----------------------------------------------------------
 string connectionString =
            "Database=C:\\Program Files\\SMCPL\\BTrekData\\BTREKML.gdb;" +
            "User=SYSDBA;" + "Password=masterkey;" +
            "Dialect=3;" + "Server=localhost;" + "Charset=BIG_5";

             FbConnection dbcon = new FbConnection(connectionString); 

             //IDbConnection dbcon = new FbConnection(connectionString); 
            dbcon.Open(); 
            FbCommand dbcmd = dbcon.CreateCommand();
                        
            string sql = "INSERT INTO MAIN 
(MAINCODE,DESCRIPTION)VALUES('F200','三') ";
 
      dbcmd.CommandText = sql; 
      FbDataReader reader = dbcmd.ExecuteReader(); 
      
            while(reader.Read()) {
       object dataValue = reader.GetValue(0); 
       szReturn += dataValue.ToString(); 
       //Console.WriteLine("Value: " + sValue);
            }
--------------------------------------------------------------------

Thanks
Regards,
Halim Setiyawan

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider