Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with national diacritics letters MySQL-VFP9
Message
De
05/02/2007 05:46:02
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Problem with national diacritics letters MySQL-VFP9
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MySQL
Divers
Thread ID:
01192316
Message ID:
01192316
Vues:
152
I got by download last ODBC driver for MySQL (ver. 3.51.12) and at first sight it was functional. Let me explain problem: I have installed MySQL 5.0 database and tables under utf8 coding. Adding, browsing and updating this database I made by php-scripts (coding of php-pages is also utf8) and everything is going fine: all national characters (Latin2 family, codepage 1250, Croatian) is appearing properly in the browser and in the database. Now I need sometime to view, put or change some records from the VFP in this MySQL database. When I connected from VFP to this database/table by ODBC using remote view data appeared and was possible to update and insert from VFP's form only if Textbox contains only English alphabet or numbers. But if I put just one or few national (diacritic) letters (like ČčĆćĐ𩹮ž) in Textbox of forms then VFP refuse to update or insert record into MySQL like I clicked on Cancel button! VFP is under Central European and font of forms is unable to change in other type. Already inserted data in MySQL appeared in the VFP's form with '?' instead adequate letters. Is there some solution good for both access to MySQL database, by php and from VFP and to keep proper view of data on both places? Thanks a lot in advance.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform