> I didn't insert it. I 'inherited' it from a (mercifully nameless) > predecessor. > I want to put this data into a database to make it easily accessible
I don't understand that. "Put data into a database" == "Insert data" (read: into a database). So either you inserted (== want to put into ...) or not inserted (== you already have it in the database and didn't insert). And regarding my other not answered questions: SQLite doesn't display data by itself. You either retrieve it in your program and display it in your program or you use sqlite3 command line tool to retrieve and display. And now pay attention: when you insert data into database you can do it in whatever encoding you like - SQLite doesn't care, doesn't check and doesn't complain if something is incorrectly encoded. When you retrieve data in your program you also can do it in whatever encoding you like - SQLite doesn't care. But if you retrieve data using command line tool sqlite3 - it does care and it assumes that your data is in correct database encoding (UTF-8 in most cases by default) and decodes it accordingly when tries to display it. So you can get a problem here. Pavel On Mon, Oct 26, 2009 at 10:28 AM, Ted Rolle <[email protected]> wrote: > On Mon, 26 Oct 2009 10:12:03 -0400 > Pavel Ivanov <[email protected]> wrote: > >> How do you insert it? How do you retrieve it? How do you display it? >> I bet the problem is in the first question, not in the last one. >> >> Pavel > > I didn't insert it. I 'inherited' it from a (mercifully nameless) > predecessor. > I want to put this data into a database to make it easily accessible > > Ted > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
