Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Problem with national diacritics letters MySQL-VFP9
Versions des environnements
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
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