Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Foreign chars, collate issues
Message
From
04/08/2011 13:36:17
 
 
To
04/08/2011 13:18:06
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01520100
Message ID:
01520183
Views:
37
>>>>HI All,
>>>>
>>>>On the same users machine at which I have a "Collating sequence PINYIN not found error" I have another error. The opening flash screen contains a text label which contains the company name and the copyright symbol as in
>>>>
>>>>
>>>>="TimBukOne ®"
>>>>
>>>>
>>>>When the flash screen attempts to display the program throws up this error message:
>>>>
>>>>
>>>>"Error loading file - record number 5. LBL_SOFTWARE Caption:Command contains unrecognized phrase/keyword"
>>>>
>>>>
>>>>I can choose Ignore on this error dialog and then I hit the Collating sequence error. Presumably this is all related to collate and code-page issues. I have never seen this behavior before.
>>>>
>>>>I have checked the project and the tables belonging to the project; all collate sequences are set to machine. I do try and create a new table during the start-up using CREATE CURSOR which does not specify a CODEPAGE. I do have in the config.fpw a CODEPAGE=1252 instruction.
>>>>
>>>>Any further ideas?
>>>
>>>Do you have any string literals with characters in the upper-ASCII range (i.e. CHR(128) thru CHR(255)) ? These will generally prove to be problematic as the characters in this range will often be used as "shift-in" and "shift-out" or "lead-in" characters to 2-byte character sequences used in Asian languages (e.g. Chinese, Korean, Japanese)..
>>
>>Thanks Naoto, I don't think so is the short answer except that the copyright symbol might well be in that range I guess?
>>
>>Tomorrow morning I am going to be able to remote access the users machine and try a few things out. will try and narrow it down to a specific line and cause. Will report back then.
>
>The problem becomes especially problematic if the character in question appears at the end of a string literal. In this particular case, the character immediately following the character gets interpreted as a second character of a 2-byte sequence representing an Asian character -- meaning that the ending quote tends to get "eaten" -- often resulting in puzzling situation where program works fine in English and most European languages, but falls on its face with program errors when run in Asian language. One workaround is to use string concatenation with CHR() function. Using the example, you could intialize the caption for the label as:
>
>="TimBukOne "+CHR(169)
>
>instead to avoid the error message (although the display may still not be correct).

I will definitely let you know tomorrow. Thanks again.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Reply
Map
View

Click here to load this message in the networking platform