Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can VFP6 read a file with utf-8 coding
Message
De
08/06/2009 16:58:24
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
08/06/2009 16:50:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01404574
Message ID:
01404579
Vues:
37
>Greetings,
>I have problem with reading of plain text file (to be honest, this file is dumped or exported MySQL table with ";" delimited fields using PHP code that shall be imported into VFP6 free table) which is utf-8 coded. I was able to handle with this problem using by VFP9 and its commands:
>
>twobyte=STRCONV(name_of_file, 11)	&&Converts UTF-8 characters in expression to double-byte characters
>
>and VFP6 doesn't have this feature! It's easy to say: Do it with VFP9 but I must to do it with VFP6!
>Due that VFP6 read special (diacritics) in file on wrong way. I wasted two week searching and trying some solution with VFP6 but haven't had luck. Is there some way to read on right way utf-8 coded text files? Thank you a lot.

I don't have VFP6 on this machine to test and say for sure but you I think you could do it via VFPOLEDB.Something like:

oCon.Execute( "update myTemp set myMemo = cast(strconv(myMemo,11) as m)")

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform