Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Kazimierz Pszenny
  Where is Kazimierz Pszenny?
 Bydgoszcz
 Poland
 Kazimierz Pszenny
 Tags
Subject: Export MySQL to SQLite
Thread ID: 462238 Message ID: 462238 # Views: 41 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, December 5, 2018 1:19:25 PM         
   


Dear Experts
I want to transfer data from the MySQL server to SQLite (.db).
When I have MySQL (mysql_obslugi) and SQLite (obslugi) cursors in Data Environment, everything works fine (OK). Data is transferred with Polish letters.
When I add data from the MySQL cursor to a table called in accordance with the attachment (SQLite), the data is transferred without Polish letters (SQLSETPROP .... SQLEXEC .... SQLCOMMIT ...).
Please help.



ENTIRE THREAD

Export MySQL to SQLite Posted by Kazimierz Pszenny @ 12/5/2018 1:19:25 PM
RE: Export MySQL to SQLite Posted by Borislav Borissov @ 12/5/2018 1:46:21 PM
RE: Export MySQL to SQLite Posted by Kazimierz Pszenny @ 12/5/2018 2:34:28 PM
RE: Export MySQL to SQLite Posted by Borislav Borissov @ 12/5/2018 3:53:30 PM