Re: How can I detect rows with non-ASCII values?

Simon Slavin <[email protected]>
Newsgroups gmane.comp.db.sqlite.general
Message-ID <[email protected]>
On 18 Jan 2020, at 12:12pm, Rocky Ji <[email protected]> wrote:

> By question marks, I meant- that some text, like Dutch programmers names, and address in Nordic locations, have accents and umaults and other such modifications done to English-alphabets. These get displayed as ? or box

SQLite doesn't display anything.  It's a database.  It stores things in a file and allows you to recall them.  It provides these facilities to programs other people write.

So you must be using a program which isn't SQLite to display those characters.  That program will be choosing whether to display them as alphabet characters with accents, or strange things like boxes and question-marks.

What program are you using to display those characters ?
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.