Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2000 Server
>hi
>
>i have some old DBF tables from Clipper that i'm trying to copy programmatically, which contain accented characters. however, when i copy the tables, i lose the accented characters.
>
>i've tried a few approaches with the same result:
>1. use, copy structure to, scatter and gather.
>2. select * from table1 into table2.
>3. use, copy to table2.
>
>i need to do this programmatically and can't just use a copy file command. also, CPDBF() on the original table returns 0, and so does the table created.
>
>any help appreciated.
>regards,
>barry
Would field by field copying work using REPLACE NewTable.Field WITH CPCONVERT(850, 1252, OldTable.Field), assuming that the tables originally contain INTERNATIONAL-DOS characters?
--
Jukka Salminen
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement