VFP Code Page Question

Hi All,

Happy New Year hope it's a prosperous one for us all! :o)

Anyway, onto business.

Is there a way that VFP7 can utilise a Code page that isn't in it's default
list ?

Obviously it can't handle unicode data but I want to be able to get at and
display CP 1258 or the Unicode CP 65000 & 65001

Is this at all possible.

There is a SYS command to change code page but can you add one for use?
Would it also be possible to set the collate order to that codepage?
Have tried SYS but it threw up an error, not a valid codepage!
Also have set windows CP to 1258 and everything works OK apart from Foxpro!
:o(

Any Help or Ideas please

TIA

Rob

Leemi
Wed Dec 31 10:52:43 CST 2003

Hi Rob:

To my knowledge, unless the codepage is listed as valid in VFP you are not
going to be able to set that code page on a table.

Code page 1258 is Vietnamese, correct? If so, you might look at this link
from Steve Black's web site. This link shows how to display Asian
Characters in VFP:

http://www.stevenblack.com/INTLUsingAsianCharacters.asp

I hope this helps and have a Happy New Year!

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retires Sept. 30th, 2003


>Hi All,

>Happy New Year hope it's a prosperous one for us all! :o)

>Anyway, onto business.

>Is there a way that VFP7 can utilise a Code page that isn't in it's default
>list ?

>Obviously it can't handle unicode data but I want to be able to get at and
>display CP 1258 or the Unicode CP 65000 & 65001

>Is this at all possible.

>There is a SYS command to change code page but can you add one for use?
>Would it also be possible to set the collate order to that codepage?
>Have tried SYS but it threw up an error, not a valid codepage!
>Also have set windows CP to 1258 and everything works OK apart from Foxpro!
>:o(

>Any Help or Ideas please

>TIA

>Rob

rob
Wed Dec 31 11:25:02 CST 2003

Thanks Lee,

I know we do this for chineese but it's one of the lucky supported
codepages.

Anyone at VFP HQ know how this can be achieved? I'd hate to have to go over
to .Net as i'm just getting to grips with vfp and there is a lot of code
that would take eons to port :o(

Rob

"Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
news:SD27I67zDHA.3088@cpmsftngxa07.phx.gbl...
> Hi Rob:
>
> To my knowledge, unless the codepage is listed as valid in VFP you are not
> going to be able to set that code page on a table.
>
> Code page 1258 is Vietnamese, correct? If so, you might look at this link
> from Steve Black's web site. This link shows how to display Asian
> Characters in VFP:
>
> http://www.stevenblack.com/INTLUsingAsianCharacters.asp
>
> I hope this helps and have a Happy New Year!
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP8 HAS ARRIVED!! --*
> Read about all the new features of VFP8 here:
> http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
> Purchase VFP8 here:
> http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retires Sept. 30th, 2003
>
>
> >Hi All,
>
> >Happy New Year hope it's a prosperous one for us all! :o)
>
> >Anyway, onto business.
>
> >Is there a way that VFP7 can utilise a Code page that isn't in it's
default
> >list ?
>
> >Obviously it can't handle unicode data but I want to be able to get at
and
> >display CP 1258 or the Unicode CP 65000 & 65001
>
> >Is this at all possible.
>
> >There is a SYS command to change code page but can you add one for use?
> >Would it also be possible to set the collate order to that codepage?
> >Have tried SYS but it threw up an error, not a valid codepage!
> >Also have set windows CP to 1258 and everything works OK apart from
Foxpro!
> >:o(
>
> >Any Help or Ideas please
>
> >TIA
>
> >Rob
>

Rob
Fri Jan 02 06:01:43 CST 2004

Lee

I have tried setting my Locale as decribed into Vietnamese which worked OK.
Windows CP is 1258

How do I get VFP7 to Display all the Characters? I have had some data sent
to me in word but I get a ? in place of some of the characters

Can foxpro display Vietnamese characters as your Article suggests?

Rgds

Rob

"Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
news:SD27I67zDHA.3088@cpmsftngxa07.phx.gbl...
> Hi Rob:
>
> To my knowledge, unless the codepage is listed as valid in VFP you are not
> going to be able to set that code page on a table.
>
> Code page 1258 is Vietnamese, correct? If so, you might look at this link
> from Steve Black's web site. This link shows how to display Asian
> Characters in VFP:
>
> http://www.stevenblack.com/INTLUsingAsianCharacters.asp
>
> I hope this helps and have a Happy New Year!
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP8 HAS ARRIVED!! --*
> Read about all the new features of VFP8 here:
> http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
> Purchase VFP8 here:
> http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retires Sept. 30th, 2003
>
>
> >Hi All,
>
> >Happy New Year hope it's a prosperous one for us all! :o)
>
> >Anyway, onto business.
>
> >Is there a way that VFP7 can utilise a Code page that isn't in it's
default
> >list ?
>
> >Obviously it can't handle unicode data but I want to be able to get at
and
> >display CP 1258 or the Unicode CP 65000 & 65001
>
> >Is this at all possible.
>
> >There is a SYS command to change code page but can you add one for use?
> >Would it also be possible to set the collate order to that codepage?
> >Have tried SYS but it threw up an error, not a valid codepage!
> >Also have set windows CP to 1258 and everything works OK apart from
Foxpro!
> >:o(
>
> >Any Help or Ideas please
>
> >TIA
>
> >Rob
>

Rick
Fri Jan 09 13:54:05 CST 2004

Rob,
According to the CPZERO.PRG, the only recognized code pages for VFP are =
listed below - 1258 is not included.

Rick

cpnums[ 1,1] =3D 437 && MS-DOS, U.S.A.
cpnums[ 2,1] =3D 850 && MS-DOS, International
cpnums[ 3,1] =3D 1252 && Windows, U.S.A & West European
cpnums[ 4,1] =3D 10000 && Macintosh, U.S.A.
cpnums[ 5,1] =3D 852 && MS-DOS, East European
cpnums[ 6,1] =3D 866 && MS-DOS, Russian
cpnums[ 7,1] =3D 865 && MS-DOS, Nordic
cpnums[ 8,1] =3D 861 && MS-DOS, Iceland
cpnums[ 9,1] =3D 895 && MS-DOS, Kamenicky (Czech)
cpnums[10,1] =3D 620 && MS-DOS, Mazovia (Polish)
cpnums[11,1] =3D 737 && MS-DOS, Greek
cpnums[12,1] =3D 857 && MS-DOS, Turkey
cpnums[13,1] =3D 863 && MS-DOS, Canada
cpnums[14,1] =3D 950 && Windows, Traditional Chinese
cpnums[15,1] =3D 949 && Windows, Korean (Hangul)
cpnums[16,1] =3D 936 && Windows, Simplified Chinese
cpnums[17,1] =3D 932 && Windows, Japanese (Shift-jis)
cpnums[18,1] =3D 874 && Windows, Thai
cpnums[19,1] =3D 10007 && Macintosh, Russian
cpnums[20,1] =3D 10029 && Macintosh, East European
cpnums[21,1] =3D 10006 && Macintosh, Greek
cpnums[22,1] =3D 1250 && Windows, East European
cpnums[23,1] =3D 1251 && Windows, Russian
cpnums[24,1] =3D 1253 && Windows, Greek
cpnums[25,1] =3D 1254 && Windows, Turkish
cpnums[26,1] =3D 1255 && Windows, Hebrew (Only supported on Hebrew OS)
cpnums[27,1] =3D 1256 && Windows, Arabic (Only supported on Arabic OS)
cpnums[28,1] =3D 1257 && Windows, Baltic
cpnums[29,1] =3D 0 && No codepage mark.


"rob" <aqwh54@dsl.pipex.net> wrote in message =
news:u5e4yh7zDHA.1736@TK2MSFTNGP09.phx.gbl...
> Hi All,
>=20
> Happy New Year hope it's a prosperous one for us all! :o)
>=20
> Anyway, onto business.
>=20
> Is there a way that VFP7 can utilise a Code page that isn't in it's =
default
> list ?
>=20
> Obviously it can't handle unicode data but I want to be able to get at =
and
> display CP 1258 or the Unicode CP 65000 & 65001
>=20
> Is this at all possible.
>=20
> There is a SYS command to change code page but can you add one for =
use?
> Would it also be possible to set the collate order to that codepage?
> Have tried SYS but it threw up an error, not a valid codepage!
> Also have set windows CP to 1258 and everything works OK apart from =
Foxpro!
> :o(
>=20
> Any Help or Ideas please
>=20
> TIA
>=20
> Rob
>=20
>

rob
Fri Jan 09 15:13:59 CST 2004

Why can't we add in new code pages that are recognised by VFP?????

Microsoft! Sort this out!!! Or do us all a favour and make it unicode
compliant!

"Rick Bean" <rgbean@unrealmelange-inc.com> wrote in message
news:%23xJdXpu1DHA.3216@TK2MSFTNGP11.phx.gbl...
Rob,
According to the CPZERO.PRG, the only recognized code pages for VFP are
listed below - 1258 is not included.

Rick

cpnums[ 1,1] = 437 && MS-DOS, U.S.A.
cpnums[ 2,1] = 850 && MS-DOS, International
cpnums[ 3,1] = 1252 && Windows, U.S.A & West European
cpnums[ 4,1] = 10000 && Macintosh, U.S.A.
cpnums[ 5,1] = 852 && MS-DOS, East European
cpnums[ 6,1] = 866 && MS-DOS, Russian
cpnums[ 7,1] = 865 && MS-DOS, Nordic
cpnums[ 8,1] = 861 && MS-DOS, Iceland
cpnums[ 9,1] = 895 && MS-DOS, Kamenicky (Czech)
cpnums[10,1] = 620 && MS-DOS, Mazovia (Polish)
cpnums[11,1] = 737 && MS-DOS, Greek
cpnums[12,1] = 857 && MS-DOS, Turkey
cpnums[13,1] = 863 && MS-DOS, Canada
cpnums[14,1] = 950 && Windows, Traditional Chinese
cpnums[15,1] = 949 && Windows, Korean (Hangul)
cpnums[16,1] = 936 && Windows, Simplified Chinese
cpnums[17,1] = 932 && Windows, Japanese (Shift-jis)
cpnums[18,1] = 874 && Windows, Thai
cpnums[19,1] = 10007 && Macintosh, Russian
cpnums[20,1] = 10029 && Macintosh, East European
cpnums[21,1] = 10006 && Macintosh, Greek
cpnums[22,1] = 1250 && Windows, East European
cpnums[23,1] = 1251 && Windows, Russian
cpnums[24,1] = 1253 && Windows, Greek
cpnums[25,1] = 1254 && Windows, Turkish
cpnums[26,1] = 1255 && Windows, Hebrew (Only supported on Hebrew OS)
cpnums[27,1] = 1256 && Windows, Arabic (Only supported on Arabic OS)
cpnums[28,1] = 1257 && Windows, Baltic
cpnums[29,1] = 0 && No codepage mark.


"rob" <aqwh54@dsl.pipex.net> wrote in message
news:u5e4yh7zDHA.1736@TK2MSFTNGP09.phx.gbl...
> Hi All,
>
> Happy New Year hope it's a prosperous one for us all! :o)
>
> Anyway, onto business.
>
> Is there a way that VFP7 can utilise a Code page that isn't in it's
default
> list ?
>
> Obviously it can't handle unicode data but I want to be able to get at and
> display CP 1258 or the Unicode CP 65000 & 65001
>
> Is this at all possible.
>
> There is a SYS command to change code page but can you add one for use?
> Would it also be possible to set the collate order to that codepage?
> Have tried SYS but it threw up an error, not a valid codepage!
> Also have set windows CP to 1258 and everything works OK apart from
Foxpro!
> :o(
>
> Any Help or Ideas please
>
> TIA
>
> Rob
>
>