468,754 Members | 1,346 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,754 developers. It's quick & easy.

Emergency: Unicode Characters in a Dataset.

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

Nov 17 '05 #1
3 5314
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
Nov 17 '05 #2
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

Nov 17 '05 #3
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


Nov 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Matt Price | last post: by
4 posts views Thread by Basil | last post: by
7 posts views Thread by Michael Davis | last post: by
14 posts views Thread by abhi147 | last post: by
8 posts views Thread by Preben Randhol | last post: by
reply views Thread by tmWin | last post: by
7 posts views Thread by 7stud | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.