Hi,
i have this Query
strQuery = string.Format("INSERT INTO [User](UserName,Password,FullName) Values('{0}','{1}','{2}')", txtUserName.Text, txtPassword.Text, txtFullname.Text);
my problem is the field UserName doesnot accept arabic charachter when i insert arabic charachter to the field txtUserName it get saved in the db ??????
note; field Usernameis set as
[Username] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
any help will be great
Regards