On 5 May 2012, at 3:49am, Dale E. Edmons <dedm...@comcast.net> wrote:
> I've built an extensive database that has three copies of the Jewish Tanach > in it. When trying to get sqlite3 to handle Hebrew (utf8 for starters) it > seems to be trying to manipulate the text and it ends up backwards. My > editors and nearly all command-line utilities don't corrupt the data, but > sqlite3 does, and I can't do any search queries. (For those not familiar with it, Hebrew is written right to left.) Some applications understand how to extract and display right-to-left, some don't. My guess is that either the one you are using to feed the database doesn't, or the one you are using to get data from the database doesn't, and you end up with reversed text somewhere along the line. You don't say what application you've been using to put your data into the database. But try grabbing a copy of the sqlite3 command-line shell and using that to access your database. http://www.sqlite.org/sqlite.html download it from here http://www.sqlite.org/download.html See if you can figure out whether your data is reversed in the database or is being reversed when you get it back out again. You could, for example, do something like SELECT substr(colName, 1, 1), substr(colName, 1, 2), substr(colName, 1, 3), substr(colName, 1, 4), substr(colName, 1, 5), substr(colName, 1, 6) FROM tableName; and see if it's building up your text from the beginning or end. If you are getting the beginnings of your words, your data is fine, and your problem is with whatever app you're using to extract it. If you're getting the ends of your words, whatever you used to feed the database did it wrong, and you're going to have to reverse the contents somehow. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
