471,322 Members | 1,781 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,322 software developers and data experts.

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 5433
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 rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.