Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Special characters
Message
From
27/05/2009 00:13:46
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01402144
Message ID:
01402165
Views:
86
This message has been marked as the solution to the initial question of the thread.
>Hi
>
>I can store "ç, é, á ," etc to my tables fields
>
>However I can not store " ã "
>
>If I try to store "nação", only "naçao" is stored
>
>I noticed that have some old tables which contains " ã "
>but I dont know the reason why I can not store it anymore

Check for cpdbf() on those tables - that should give you your codepage. Then set that codepage (in config.fpw) before creating your tables, or use home()+"tools\cpzero\cpzero.prg" to set that codepage on your existing tables. First parameter is (full) filename, second (numeric) the codepage number. You'd need to do that with all of your tables where you may have Portuguese text - dbf, scx, vcx, mnx, frx, lbx, pjx etc. Keep in mind that if you have pieces of code in different codepages in the same project, it will recompile everything every build, even if you don't tell it to.

Then try with Portuguese characters. It should work.

Alternately, you can set all your character fields to binary, which should prevent any conversion, and set your .fontcharset property of all your classes (anything that has a .caption or .value should have that property too) and _screen and what have you to use your codepage. The first approach, however, is better, less work and fewer things to cover.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform