<% 'utf8 connection Set cn2 = CreateObject ("ADODB.Connection") cn2.ConnectionString = "Driver={MySQL ODBC 5.1 Driver};Port=3306;Option=3;Server=webix.me;User ID=root;Password=cancelca1;Database=webix;charset=utf8" cn2.open '******************************************************** ' Saves data ok '******************************************************** SQL = "SELECT hebrewText FROM test WHERE 1=0" Set rs1 = CreateObject ("ADODB.Recordset") rs1.CursorType = 0 rs1.LockType = 3 rs1.open SQL, cn2 rs1.addNew rs1("hebrewText") = "שלום" rs1.update rs1.close Set rs1 = Nothing '******************************************************** ' Saves data incorrectly '******************************************************** SQL = "INSERT INTO test (hebrewText) VALUES ('שלום')" cn2.execute SQL cn2.close Set cn2 = Nothing %>