Here what I did:
string cmdText = String.Format(("CREATE TABLE {0} (dno int primary key, Sunday char(5), Monday char(5), Tuesday char(5), Wednesday char(5), Thursday char(5), Friday char(5))"), tableName);
OleDbConnection conn = new OleDbConnection(Form1.ConnectionString);
conn.Open();
OleDbCommand cmd = new OleDbCommand(cmdText, conn);
cmd.ExecuteNonQuery();
conn.Close();
And it works great, but when I try put Hebrew in it (notice the string cmdText)
string cmdText = String.Format("CREATE TABLE {0} (dno int primary key, יום א char(5), יום ב char(5), יום ג char(5), יום ד char(5), יום ה char(5), יום ו char(5))", tableName);
OleDbConnection conn = new OleDbConnection(Form1.ConnectionString);
conn.Open();
OleDbCommand cmd = new OleDbCommand(cmdText, conn);
cmd.ExecuteNonQuery();
conn.Close();
It doesnt work and causes an exception... anyone know why it doesnt support hebrew, and if theres a way to fix it?