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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 42

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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

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…
The well known Cerber ransomware continues to spread this summer through spear phishing email campaigns targeting enterprises. Learn how it easily bypasses traditional defenses - and what you can do to protect your data.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

762 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