Emergency: Unicode Characters in a Dataset.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi,

There are probably issues with communicating to database as .net is fully
unicode.
What database do you use and how does look like your DataAdapter?
 
Hi Miha
I'm using Microsoft Access database (MDB). And what are you mean how does my
DataAdapter look like?
Thanks in advance.

Miha Markic said:
Hi,

There are probably issues with communicating to database as .net is fully
unicode.
What database do you use and how does look like your DataAdapter?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

Mohammad-Reza said:
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
Click to expand...
Click to expand...
 
HI Mohammad-Reza,


Mohammad-Reza said:
Hi Miha
I'm using Microsoft Access database (MDB). And what are you mean how does
my
DataAdapter look like?
Click to expand...

Your adapter.SelectCommand.CommandText ... InsertCommand, UpdateCommand
Are your fields in access defined as unicode?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

Thanks in advance.

Miha Markic said:
Hi,

There are probably issues with communicating to database as .net is fully
unicode.
What database do you use and how does look like your DataAdapter?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

Mohammad-Reza said:
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
Click to expand...
Click to expand...
Click to expand...
 
Just a guess, Mohammad, are you using a font that can display these Unicode
characters for the textboxes?



Miha Markic said:
HI Mohammad-Reza,


Mohammad-Reza said:
Hi Miha
I'm using Microsoft Access database (MDB). And what are you mean how does
my
DataAdapter look like?
Click to expand...

Your adapter.SelectCommand.CommandText ... InsertCommand, UpdateCommand
Are your fields in access defined as unicode?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

Thanks in advance.

Miha Markic said:
Hi,

There are probably issues with communicating to database as .net is
fully
unicode.
What database do you use and how does look like your DataAdapter?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

message
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
Click to expand...
Click to expand...
Click to expand...
 
I use this font in a normal application without database and worked correctly.
By the way, Miha I don't know how to chech that the fields are unicode in
access or not, would you please tell me?

Wencheng Magiya said:
Just a guess, Mohammad, are you using a font that can display these Unicode
characters for the textboxes?



Miha Markic said:
HI Mohammad-Reza,


Mohammad-Reza said:
Hi Miha
I'm using Microsoft Access database (MDB). And what are you mean how does
my
DataAdapter look like?
Click to expand...

Your adapter.SelectCommand.CommandText ... InsertCommand, UpdateCommand
Are your fields in access defined as unicode?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

Thanks in advance.

:

Hi,

There are probably issues with communicating to database as .net is
fully
unicode.
What database do you use and how does look like your DataAdapter?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

message
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
Click to expand...
Click to expand...
Click to expand...
 
If data shown in access is proper then issue can be solved by
system.gobalization name space.

regards
bhawin13
 
Hi Mohammad-Reza,

I looked into Access 2003 and I saw that both TEXT and CHAR fields are
unicode fields. That's fine. Are you using Access 2003?
So, go to
Windows Form Designer generated code

region in your form's file and there you'll see your dataadapter being
initialized.


--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info



Mohammad-Reza said:
I use this font in a normal application without database and worked
correctly.
By the way, Miha I don't know how to chech that the fields are unicode in
access or not, would you please tell me?

Wencheng Magiya said:
Just a guess, Mohammad, are you using a font that can display these
Unicode
characters for the textboxes?



Miha Markic said:
HI Mohammad-Reza,


message
Hi Miha
I'm using Microsoft Access database (MDB). And what are you mean how
does
my
DataAdapter look like?

Your adapter.SelectCommand.CommandText ... InsertCommand, UpdateCommand
Are your fields in access defined as unicode?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info


Thanks in advance.

:

Hi,

There are probably issues with communicating to database as .net is
fully
unicode.
What database do you use and how does look like your DataAdapter?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

message
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top