Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing Russian Data in DBF File (URGENT)
Message
 
À
22/11/2004 08:18:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
00963450
Message ID:
00963458
Vues:
6
Hi Munir,

Apparently it is code page translation problem.
Difficult to say without having a copy of the actual text file and knowing how it was created (Windows, DOS, any code page used when saving TXT file), but try to play with code page settings.

For example if your Russian text corresponding to Windows 1251 code page was created and saved in English DOS (code page 437), then you will see something like this with:
Append From C:\Test\Russian.Ref delimited with char @
RU@0@11@21430@@C+C@10@0@@OAOOIE-™IOD III@ @RU@109017@II¥EAA@EAŽAOA¥EAá IA

and this with
 Append From C:\Test\Russian.Ref delimited with char @ AS 437
RU@0@11@21430@@C+C@10@0@@OAÉOOIE-ÖÅIOD III@ @RU@109017@IIÑEAA@EAÄAOÅAÑEAß IA

>Hi Experts,
>
>I need an URGENT help from you. I am having a text file which looks like below:
>
>RU@0@11@21430@11@C+C@110@0@@ÓÀÉÒÕÎË-ÖÅÍÒÐ ÎÎÎ@ @RU@109017@ÌÎÑÊÂÀ@ÊÀÄÀØÅÂÑÊÀß ÍÀ
>
>There are russian characters inside the text file. I am having a table in which I want to insert this data. When I am using
>
>Append From C:\Test\Russian.Ref delimited with char @
>
>When the data is imported the characters shown in the table is not russian. This is happening with append from command. But When I am issuing a Insert SQL or append blank and typing the characters I am able to type in.
>
>Can anyone explain me how to import the russian characters (in text file) into table which can be seen in browse command.
>
>Thanks in Advance.
>
>Regards
>
>Munir
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform