Hi all,
One of our clients converted their SAP Oracle database to UTF8 (3 byte char) scheme. As such, a VARCHAR2(10) is actually 30 characters in VFP. This had the effect of all character field lengths are now multiplied by 3 and is causing problems in our VFP application left and right.
We had a similar issue with a Russian client where their Oracle data is in UTF8 (double-byte) but we were able to resolve it by setting the following:
1. Oracle ODBC NLS_LANG = RUSSIAN_CIS.CL8MSWIN1251
2. SET CODEPAGE=1251
3. All tables (.dbf) are set to 1251
4. FontCharSet = 206
I don't see a setting in VFP to set the codepage to UTF8 or for a 3-byte character storage in the VFP tables. Using STRCONV() - not even sure if this will work - would require changing almost all programs in our application.
Any suggestions?
ramil
~~ learning to stand still