Nov-11-2019, 11:21 PM
Hello,
For some reason, the input data that are in UTF8 in SQLite end up as Latin1 in the output file:
Am I missing a switch somewhere?
Thank you.
For some reason, the input data that are in UTF8 in SQLite end up as Latin1 in the output file:
import gpxpy.gpx import sqlite3 gpx = gpxpy.gpx.GPX() con = sqlite3.connect('input.sqlite') con.row_factory = sqlite3.Row cur = con.cursor() cur.execute("SELECT name,latitude,longitude FROM table1"); results = cur.fetchall() for row in results: w1 = gpxpy.gpx.GPXWaypoint(row["latitude"],row["longitude"]) w1.name = row["name"] gpx.waypoints.append(w1) print("Waypoint: ",w1.name) with open("map.gpx", "w") as f: f.write( gpx.to_xml())I'm pretty sure data in SQLIte are in UTF8 because a run of ".output test.csv ; SELECT …" shows data in UTF8, so it looks like the issue lies in the code above.
Am I missing a switch somewhere?
Thank you.