Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting language characters
Message
From
16/12/2022 00:14:39
 
 
To
15/12/2022 19:22:07
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01685507
Message ID:
01685519
Views:
56
Likes (1)
>>>Hi. I use XCASE Professional Edition 10.1 for designing my SQL Server databases. When defining the fields for any given entity I can enter the physical name of the field as well as its Title, among other properties. For example when I cant to define the customer address ("dirección del cliente" in spanish) field I enter:
>>>
>>>For the name of the field: "cDireClie"
>>>For the title of the field: "Dirección del cliente" (customer address in spanish)
>>>
>>>Everything's fine until that point. But I want to feed my own data dictionary with data that's stored in XCASE's tables. So, in Visual FoxPro 9 I open the fields table (DDFLD.DBF) and when I nagigate to the record that has the data I entered above, I see in the "Title" field's content this: "Direcci¢n del cliente", as you can see the "ó" char I entered in XCASE is seen within Visual FoxPro as "¢". What can I do to see it back as "ó"?
>>>
>>>TIA
>>
>>Luís,
>>
>>
>>? CPCONVERT(850, 1252, "Direcci¢n del cliente")
>>
>>
>>will produce
>>
>>Dirección del cliente
>>
>>
>>When DDFLD is open in the current area, what is the value of
>>
>>
>>? CPDBF()
>>
>
>
>? CPDBF()
>
>
>Returns 0

I don't know which codepage is most relevant in your country, but I guess it's 1252. Run this command:
(Home(1)+'tools\cpzero\cpzero.prg') with 'yourtable.dbf', 1252
For more info, check https://www.vfphelp.com/vfp9/_5wn12p9uo.htm
Previous
Reply
Map
View

Click here to load this message in the networking platform