Sunday, March 11, 2012

Creating SDF file with Japanese characters

Hi,

I need to have an SDF file with Japanese characters, to be read on Windows Mobile 2003. I'd like to create this file with my PC, since I don't seem to be able to create cells containing Japanese characters using directly SQL Query on the PPC.

So far, I see 2 options:

1) Creating an MDF file with Japanese characters (no problem), then use a tool to convert this MDF file to SDF. I've tried the 3rd party Primeworks tool that has been suggested on Forums, but it doesn't offer the Japanese language option, so when I try to read the generated SDF file on my PPC, I get squares instead of characters.
I'm not sure if I can use SQL Server Integration Services to convert my file; it seems so, but I'm not sure which tool to download. (Any idea?)

2) Using SQL Server Management Studio, with SQL Server Mobile, and creating an SDF file. I can create tables with Japanese characters in it, but I cannot read the generated SDF file on Windows Mobile 2003 (it's probably compatible only with WM5, since I think the tool was designed for it)

Can anyone help me resolving the final steps to make one of these options work?

Thanks very much!!

"Squares" usually mean you don't have fonts to display particular characters (expected unless your device is localized in Japanese) - your database might be OK. Try that on Japanese device (or emulator) and see if characters are shown properly.

No comments:

Post a Comment