Urgent: Codepage settings on a remaote view

[marco]

Hello there,

I hope there is somebody who's able to help me with my problem.

This is the situation.
I have a table (dbf) with data that has to be imported into the database on
Sybase Ase 12.5.1. The database and server is configured to handle the old
codepage ms-dos 850. The table that has to be imported is also cp 850.

I've made a remote view in foxpro that handles the data using a remote view.
But de remote view is automaticly configured as windows code page 1252.

Now I have a conversion problem with the special characters like é,ö etc.

Is it posible that de codepage format of the remote view can ba altered to
cp-850?

Thanks in advance.,

[Anders Altberg]

You can use CPCONVERT() on the text columns to convert you Windows
characters to MS-DIOS 850 characters.
The COPY TO command has an AS <codepage> clause to convert an entire table
If your VFP table isn't properly marked with the 850 codepage, use
Tools\Cpzero\cpzero.prg to set the codepage mark.
You can set VFP to make 850 the default by setting CODEPAGE=850 in
Config.fpw. Put the configuration file in the startup folder of a your
compiled export/import applications's exe.
-Anders

Post by marco
Hello there,
I hope there is somebody who's able to help me with my problem.
This is the situation.
I have a table (dbf) with data that has to be imported into the database on
Sybase Ase 12.5.1. The database and server is configured to handle the old
codepage ms-dos 850. The table that has to be imported is also cp 850.
I've made a remote view in foxpro that handles the data using a remote view.
But de remote view is automaticly configured as windows code page 1252.
Now I have a conversion problem with the special characters like é,ö etc.
Is it posible that de codepage format of the remote view can ba altered to
cp-850?
Thanks in advance.,