jeudi 10 septembre 2015

SQLite - Trying to read a file with SQL which contains text with special characters causes strange symbols

I am trying to create a SQL script that can be used to generate a database with a set of data, but once I try to read the script in SQLite, special characters(specifically n with tilde) becomes unreadable by humans. Here is an example of a script with the issue:

create table if not exists person(
      id integer primary key not null, --auto increment key
      name text NOT NULL
      );

begin transaction;

insert into person(name) values ('señor');

end transaction;

Running the Query "SELECT * FROM person;" returns the following result:

1|se├▒or

My class requires that I am able to show special symbols within the sqlite command line app. If I copy and paste the insert command into the sqlite console, then the value will be displayed properly.

Aucun commentaire:

Enregistrer un commentaire