Emergency: Unicode Characters in a Dataset.

[Mohammad-Reza]

We are writing an application for a specific culture(Arabic or Farsi).
This application involves using DataAdapter, OLEDB Connection and the DataSet.
We didn't use the .NET data binding, just field TextBoxes with the data
retrieved from the DataSet but whole system seems to be unable to update the
database (.mdb file) with Unicode characters. Instead of displaying the
correct characters the application displays question marks (?).
Isn't there any way of saving Unicode characters in the database using this
system?
This is an emergency…
Thanks in advance

[Jon Skeet [C# MVP]]

Mohammad-Reza <Mo**********@discussions.microsoft.com> wrote:

We are writing an application for a specific culture(Arabic or Farsi).
This application involves using DataAdapter, OLEDB Connection and the DataSet.
We didn't use the .NET data binding, just field TextBoxes with the data
retrieved from the DataSet but whole system seems to be unable to update the
database (.mdb file) with Unicode characters. Instead of displaying the
correct characters the application displays question marks (?).
Isn't there any way of saving Unicode characters in the database using this
system?

The first thing you need to find out is exactly what level the problem
is occurring at.

See http://www.pobox.com/~skeet/csharp/d...ngunicode.html

When you've worked out from that where the problem is, if you post your
results we can probably work out what's wrong.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Bob Milton]

Is the database setup to handle Unicode characters? If the columns you
update are VARCHAR columns, then the server will convert your Unicode to
8-bit characters based on ITS local (not the clients). The database needs to
be set for NVARCHAR columns. [This all presumes SQL Server]
Bob
"Mohammad-Reza" <Mo**********@discussions.microsoft.com> wrote in message
news:67**********************************@microsof t.com...

We are writing an application for a specific culture(Arabic or Farsi).
This application involves using DataAdapter, OLEDB Connection and the
DataSet.
We didn't use the .NET data binding, just field TextBoxes with the data
retrieved from the DataSet but whole system seems to be unable to update
the
database (.mdb file) with Unicode characters. Instead of displaying the
correct characters the application displays question marks (?).
Isn't there any way of saving Unicode characters in the database using
this
system?
This is an emergency.
Thanks in advance

[Mohammad-Reza]

Hi Bob
I use MDB file and simply use Data adapter. what i must do now?

"Bob Milton" wrote:

Is the database setup to handle Unicode characters? If the columns you
update are VARCHAR columns, then the server will convert your Unicode to
8-bit characters based on ITS local (not the clients). The database needs to
be set for NVARCHAR columns. [This all presumes SQL Server]
Bob
"Mohammad-Reza" <Mo**********@discussions.microsoft.com> wrote in message
news:67**********************************@microsof t.com...

We are writing an application for a specific culture(Arabic or Farsi).
This application involves using DataAdapter, OLEDB Connection and the
DataSet.
We didn't use the .NET data binding, just field TextBoxes with the data
retrieved from the DataSet but whole system seems to be unable to update
the
database (.mdb file) with Unicode characters. Instead of displaying the
correct characters the application displays question marks (?).
Isn't there any way of saving Unicode characters in the database using
this
system?
This is an emergency.
Thanks in advance