1/2 character (chr(189)) not appearing correctly on PPC

  • Thread starter Thread starter NerdRunner
  • Start date Start date
N

NerdRunner

I am transferring data from a Lotus Approach database using a vb.net
web service. The data is linked into an MS Access database in order
to do some linking of data. Some of the fields contain the ½
character. When these fields are transferred to the handheld I see a
"box" character instead.

I noticed that within Access, those fields with ½ show ╜instead. (½
can be created using alt+0189 on your keyboard and â•œcan be created
using alt+189 on your keybaord) When I check the ascii value of â•œI
get a value of 43, which seems odd.

Data that is native to my Access database that contain ½ transfer and
display ½ without any issues.

Transferring data collected on the PPC that contain ½ into the Lotus
database shows « instead. « has an ascii value of 171.

I would think that the characters would transfer without issue since
two common fonts are being used (Arial in Approach and Tahoma on the
PPC).

Some insight as to how I can get the ½ character to transfer to and
from the handheld would be helpful. and greatly appreciated.

Thanks,

Sean M. Severson
 
Have you tried HTML encoding the string on the web service side, and then
performing a HTML decode on the pocket pc. This should ensure you don't
incorrectly transfer the data during the HTTP request.

Rick D.
Contractor
 
This should get you up to speed on Unicode which Windows Mobile/CE is using
and explain why code 189 can be shown as any number of different characters
depending on encoding.



http://www.joelonsoftware.com/articles/Unicode.html


--
Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

*** Want to find answers instantly? Here's how... ***

1. Go to
http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en
2. Type your question in the text box near "Search this group" button.
3. Hit "Search this group" button.
4. Read answer(s).

I am transferring data from a Lotus Approach database using a vb.net
web service. The data is linked into an MS Access database in order
to do some linking of data. Some of the fields contain the ?
character. When these fields are transferred to the handheld I see a
"box" character instead.

I noticed that within Access, those fields with ? show ­instead. (?
can be created using alt+0189 on your keyboard and ­can be created
using alt+189 on your keybaord) When I check the ascii value of ­I
get a value of 43, which seems odd.

Data that is native to my Access database that contain ? transfer and
display ? without any issues.

Transferring data collected on the PPC that contain ? into the Lotus
database shows < instead. < has an ascii value of 171.

I would think that the characters would transfer without issue since
two common fonts are being used (Arial in Approach and Tahoma on the
PPC).

Some insight as to how I can get the ? character to transfer to and
from the handheld would be helpful. and greatly appreciated.

Thanks,

Sean M. Severson
 
I am transferring my data via a dataset, not as a string. I'm using a
web service to transfer a dataset to and from the handheld.

Sean M. Severson
 
The problem does not appear to be with the transfer of data from the
webservice to the handheld. If I enter the ½ character into a table
in my Access database, the ½ character transfers just fine. It is
when I try to read the ½ character from the linked Lotus Approach
database and transfer it to the handheld that the problem appears. As
I stated earlier, I cannot even get the ½ character to appear
correctly in the linked Lotus Approach table in my Access database. I
will post in the Access newsgroup regarding this and see if I can at
least get Access to display the character correctly.

Sean M. Severson
 
Back
Top