I am attempting to read data generated by a PAT simulation into python using the associated .sql file. The sql file opens fine in the Data Viewer, but when importing into python, I receive the following error: "'utf-8' codec can't decode byte 0xa8 in position 27: invalid start byte". I have also tried importing the file using Microsoft SQL Server Management Studio but get similar warnings regarding the encoding.
Opening the file in a text editor, I see this in the header:
SQLite format 3 @ ¨ ½ 2 ¨ .CÃ ì (ûöñìN’ä«F ƒ
I am new to PAT and SQL...is there something I am missing about the encoding/decoding of this file that would make it useable? It looks very different in the text editor from other SQL files I have seen.
