Microsoft.Data.Sqlite: Store char as TEXT

[bricelam]

Again, like #15019, it's probably too late, but I wish we could store char values as TEXT. This would make databases way more compatible with external systems.

Today, we store the UTF-16 character code as an INTEGER.

[bricelam]

Use SQL like this to update existing databases.

UPDATE MyTable
SET CharColumn = char(CharColumn)
WHERE typeof(CharColumn) = 'integer';

[bricelam]

EF queries like this will be broken on existing databases:

var yeas = from v in db.Votes
           where v.Value == 'Y'
           select v;