[Webinar] Streamline your web hosting managementRegister Today


How do i display Chinese Simplified properly in VFP9 ?

Posted on 2010-01-09
Medium Priority
Last Modified: 2012-05-08

  previously, i use vfp9 to write a program. the system show no problem to display  Chinese Tradisional character (BIG5). but when i use Chinese Simplified character (GB), SOME chinese character will show questionmark (?), so i try the Chinese Simplified on other software like MS Word, IE or Notepad; nothing wrong, so i suspect maybe the Chinese Simplified character is not compatible with VFP. pls advise.

  by the way, i am using Chinese (PRC) and Chinese (taiwan)  IME from Control Panel -> Regional and Language options, my OS is Windows XP SP3
Question by:Darren_Ang
LVL 43

Accepted Solution

pcelba earned 500 total points
ID: 26273292
VFP does not support Unicode natively. If you need to display Unicode characters then you need some conversion and appropriate font to display the results. But this you probably know.

Questionmarks are caused either by impossible conversion or by font which does not support such characters. Both font and conversion routine is provided by operating system and VFP has no influence on it. If the character is displayed correctly in Unicode enabled software then the most probably reason is conversion. You should test you app on newer OS (Vista, W7) with chinese support installed.

Sorry I cannot help more.

Rick Strahl published interesting paper about Unicode in VFP on his web:

This discussion could give you more info (and see links at the end):

This link worked for me from Google cache:
LVL 27

Expert Comment

ID: 26273649
You can store unicode in memo fields but you have to convert them in a special way and when you export to Word or Excel they look perfect.

You can on the other hand, have the code page or locale switched to another language in VFP and the OS, you can import normal into a DBF and when you export it will show correctly in Word or Excel but not inside VFP.
LVL 30

Assisted Solution

by:Olaf Doschke
Olaf Doschke earned 500 total points
ID: 26276622
You'll find detailed explainations here for Japanese, which can also be applied to simplified chinese: http://stevenblack.com/INTLUsingAsianCharacters.html

It's a bit more than codepage and font, which you need to setup.

Bye, Olaf.

Author Comment

ID: 26338433

  i just came back from holiday, i will go though the solution provided by pcelba and Olaf asap, thanks a lot

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
Here is a method which can be used to help resolve a "Content Index Failed" error on a Microsoft Exchange Server.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question