TEXT vs. BLOB on SQLite Android Server on Negotiation Values

Question

I have a sqlite BD with a table containing the coordinates of a large polyline (about 2000 characters). BD structure:

CREATE TABLE "province" (
    `_id`   INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
    `_line` TEXT,
);

The format of the _line values ​​is:

lat1,lon1;lat2,lon2;lat3,lon3;lat4,lon4 ...

A small example:

28.164033,-15.709076;28.151925,-15.699463;28.134972,-15.703583;28.121650,-15.707703;28.107115,-15.704956;28.079250,-15.713196;28.067133,-15.735168

Currently, the _line field is of type TEXT in the Android SQLite database. In my DAO class, I parse this line into an ArrayList, this is a list of points.

My question is, will it be recommended to change the _line data type from TEXT to BLOB ? Will performance improve?

Answer 1

TEXT BLOB . - , , .

Android TEXT (UTF-8) Java (UTF-16). BLOB.

, , , , UTF-16, .