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.

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.

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.