memo binary foreign accents

[juandiegomc]

Hello,


I have a problem with many accents of foreign languages

like Polish which I can't get foxpro memo fields to accept.

I thought binary memo fields would do the trick but not so

I opened the table exclusively and did a modify structure, made the memo a memo binary field. But it still only replaces all of the accents with ? question marks. Any help or advice.

 

[wgcs]

The memo field is storing what you give it, but VFP doesn't know how to display the characters.

It seems to me that the "?" chars are used to display any unicode characters that aren't in the standard display set of characters. There are encodings other than Unicode which VFP probably can display.

 

[juandiegomc]

tnx wgcs,

I tried it as a common memo field and then tried to make a memo (binary) field, but both of them reject the accents.

I am using Windows XP and this receives the accents in my excel tables, strange foxpro won't?

 

[medic]

Have you tried playing with the code page of your table?

 

[juandiegomc]

No I have not played with the code page.

I feel this is so strange, since a word-pad

receives these Polish accents, and also my

excel spread sheet also receives them, so why

does not a memo or a memo binary field not

receive them?

 

[Mike Lewis]

juandiegomc,

You should not be using binary memos, since the whole point of those is to prevent the translation of code pages. Just use an ordinary memo.

Next, check the code page that was in force when the table was created. Uses the CPDBF() function for that. For Polish, it should tell you that the code page is 620.

If the code page is not 620, copy the table to a new table, using the AS clause to specify the code page. For example:

USE OldTable
COPY TO NewTable AS 620

Finally, make sure that the font you are using can display the required characters. If you can see the characters in Wordpad, use the same font in VFP.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com