|
Home > Archive > FoxPro database connector > April 2005 > Re: How to specify the CODEPAGE in SELECT SQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: How to specify the CODEPAGE in SELECT SQL
|
|
| Marek Hryceniak 2005-04-07, 8:05 pm |
|
>Uzytkownik "Stoyan Malchev" <ptg_soft@mail.orbitel.bg> napisal w wiadomosci
>news:%2369LadyFFHA.3648@TK2MSFTNGP10.phx.gbl...
>Is it possible to specify the codepage for mytable in the statment
>select * from mytable
>Thanks in advance
Hello Stoyan,
Maybe you should set your table's codepage once and perform "normal" ;-)
selects?
cMyTablePath = "C:\mytable.dbf"
nTableCodepage = 852
DO (HOME(1)+"Tools\CpZero\CpZero.prg") with cMyTablePath, nTableCodepage
If you can't do that , then look at the CPCONVERT( ) function.
--
Pozdrawiam,
Marek Hryceniak
| |
| Stoyan Malchev 2005-04-07, 8:05 pm |
| Thanks, Marek
But I am looking for a way to set the codepage without modifying the source
table
"Marek Hryceniak" <marek_usunto@mcm.pl> wrote in message
news:uXJv$bGGFHA.208@TK2MSFTNGP12.phx.gbl...
>
wiadomosci[color=dar
kred]
>
>
> Hello Stoyan,
>
> Maybe you should set your table's codepage once and perform "normal" ;-)
> selects?
>
> cMyTablePath = "C:\mytable.dbf"
> nTableCodepage = 852
> DO (HOME(1)+"Tools\CpZero\CpZero.prg") with cMyTablePath, nTableCodepage
>
>
> If you can't do that , then look at the CPCONVERT( ) function.
>
>
> --
> Pozdrawiam,
> Marek Hryceniak
>
| |
| Anders Altberg 2005-04-07, 8:05 pm |
| As of VFP9 you can add CODEPAGE=nCodepage to the CREATE TABLE and CREATE
CURSOR commands
CREATE CURSOR xx CODEPAGE=936 (id Integer, name Character, registered
Datetime. Mem Memo NoCPTrans )
INSERT INTO xx SELECT * FROM my_other_code_page_t
able
I haven't checked but the may be like performing a CPCONVERT() on all
character convertible fields.
-Anders
"Stoyan Malchev" <ptg_soft@mail.orbitel.bg> wrote in message
news:#LNDSvKGFHA.2180@TK2MSFTNGP10.phx.gbl...
> Thanks, Marek
> But I am looking for a way to set the codepage without modifying the
source
> table
>
>
> "Marek Hryceniak" <marek_usunto@mcm.pl> wrote in message
> news:uXJv$bGGFHA.208@TK2MSFTNGP12.phx.gbl...
> wiadomosci
nTableCodepage[color
=darkred]
>
>
|
|
|
|
|