SQL CE Database(.sdf) on device Unicode Character...

Arun, Thanks for getting back.

I didn't set any specific font on my combobox and listbox controls.
They use the default ones. I tried many things like setting up font for
listview to "Angsana new" (thai font) but that too didnt work.

Initially, I tested on Audiovox PPC4100 which showed me the same
symptoms..Then i had tried on ASUS P505. In this model, the listview
control worked fine and thai chars were being displayed, but since last
3 days, even on my ASUS model, thai fonts on listview control are not
being displayed. I tried uninstalling and re-installing the app and
sqlce.cab files, but no luck.

I have one question here - Why the data in SQL CE when viewed through
query analyzer from PPC displays "square brackets" instead of thai
language? I tried creating a new db on device with "Thai" collation and
then replicated the data again, but still no luck..

Anyway, thanks. Let's see if there's some other workaround.

Dilip

Surprisingly you have combobox and listbox working properly, so you
have Thai fonts installed on your PPC.

Check whether you have the fonts set to all the controls are similar.
Might be you can try to set all the controls to the default.

Always try with devices you have. You have not mentioned anything
specific about the device or the PPC version. Pocket PC is software
platform from OEM sits over WinCE so try with a different device or in
different PPC versions and please let us know how it works.

Hope this helps,
Cheers,
Arun.
www.innasite.com

Hi, I haven't yet got any replies of this problem of mine. Are the
gurus on a vacation?