Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing Russian Data in DBF File (URGENT)
Message
 
To
22/11/2004 08:18:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00963450
Message ID:
00963458
Views:
5
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
Previous
Reply
Map
View

Click here to load this message in the networking platform