C# and SQL server problem

[mostafa atalla]

Dear sirs:
I'm making an application using C# and i connect through
it to a database made by MSSQL server but i have a problem
when inserting or updating in the database in arabic that
each arabic letter is replaced by a question mark (?)
the code i'm using to insert is
oleDbDataAdapte r1.InsertComman d.CommandText=" sql
Statement";
and to update is:
oleDbDataAdapte r1.UpdateComman d.CommandText=" sql
statement";
Note:
I successeded to insert and to update in english by that
code but the problem is in arabic

[Nicholas Paldino [.NET/C# MVP]]

Mostafa,

Is the column you are trying to enter data into an nvarchar or nchar
column? These columns can handle unicode characters, whereas the char and
varchar are ansi characters.

Also, you have to make sure your string is prefixed with n (e.g. n"my
string") to make sure it is interpreted as a unicode string.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"mostafa atalla" <mo***********@ discussions.mic rosoft.com> wrote in message
news:A5******** *************** ***********@mic rosoft.com...

Dear sirs:
I'm making an application using C# and i connect through
it to a database made by MSSQL server but i have a problem
when inserting or updating in the database in arabic that
each arabic letter is replaced by a question mark (?)
the code i'm using to insert is
oleDbDataAdapte r1.InsertComman d.CommandText=" sql
Statement";
and to update is:
oleDbDataAdapte r1.UpdateComman d.CommandText=" sql
statement";
Note:
I successeded to insert and to update in english by that
code but the problem is in arabic

[Paul W]

> "mostafa atalla" <mo***********@ discussions.mic rosoft.com> wrote in
message

news:A5******** *************** ***********@mic rosoft.com...

Dear sirs:
I'm making an application using C# and i connect through
it to a database made by MSSQL server but i have a problem
when inserting or updating in the database in arabic that
each arabic letter is replaced by a question mark (?)
the code i'm using to insert is
oleDbDataAdapte r1.InsertComman d.CommandText=" sql
Statement";
and to update is:
oleDbDataAdapte r1.UpdateComman d.CommandText=" sql
statement";
Note:
I successeded to insert and to update in english by that
code but the problem is in arabic

This can also be caused by your SQL Server's collation. By default, SQL
collation is SQL_Latin1_Gene ral_CP1_CI_AS, which is not Arabic. For Arabic
characters, you'll probably need to set your field's collation, or change
the database default, to SQL_Latin1_Gene ral_Cp1256_CS_A S.

For more on collation:

http://msdn.microsoft.com/library/en...ation_8f8w.asp
http://msdn.microsoft.com/library/en...ca-co_5ell.asp

[Hans Kesting]

"mostafa atalla" <mo***********@ discussions.mic rosoft.com> wrote in message
news:A5******** *************** ***********@mic rosoft.com...

Dear sirs:
I'm making an application using C# and i connect through
it to a database made by MSSQL server but i have a problem
when inserting or updating in the database in arabic that
each arabic letter is replaced by a question mark (?)
the code i'm using to insert is
oleDbDataAdapte r1.InsertComman d.CommandText=" sql
Statement";
and to update is:
oleDbDataAdapte r1.UpdateComman d.CommandText=" sql
statement";
Note:
I successeded to insert and to update in english by that
code but the problem is in arabic

Are you specifying the values within the sql-string
(insert into names_table (name) values ('Hans') ) ?
If so, you might need to look at parameters.
For plain english you then avoid problems with names like O'Brien.
It might work with your arabic texts as well (if the columns
accept unicode strings, see the other replies)

Hans Kesting