Re: Urgent: Codepage settings on a remaote view
From: Anders Altberg (x_pragma_at_telia.com)
Date: 09/27/04
- Next message: Rick Bean: "Re: FoxPro 2.6 ODBC Driver questions"
- Previous message: marco: "Urgent: Codepage settings on a remaote view"
- In reply to: marco: "Urgent: Codepage settings on a remaote view"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 27 Sep 2004 13:43:21 +0200
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
"marco" <marco@discussions.microsoft.com> wrote in message
news:7FBE4174-3EA3-408D-8E78-CE1BDA1E0F5A@microsoft.com...
> 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.,
>
- Next message: Rick Bean: "Re: FoxPro 2.6 ODBC Driver questions"
- Previous message: marco: "Urgent: Codepage settings on a remaote view"
- In reply to: marco: "Urgent: Codepage settings on a remaote view"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
