Richard,
bash scripts, command-line shell and vim.
I discovered that I was missing the -H option on vim. More than likely
it is a vim problem, not sqlite3. vim seems to work flawlessly with one
particular text, but some aren't standardized. My bad. Other Hebrew
texts were/are working fine. Some are in standard string order, some
are reversed to account for software that doesn't display R->L languages
correctly.
I think I'll write a utility to discover the direction of any particular
text. Usually I sort it out, but this one caught me unaware.
I've been using sqlite3 for about three years on this project and I
really appreciate the work that has been done on sqlite3--thanks all!
(I was a (volunteer) Linux developer until I lost my job in '09, but I'm
trying to get back to more activity.)
Thanks.
D.E.
Richard Hipp wrote:
On Fri, May 4, 2012 at 10:49 PM, Dale E. Edmons <dedm...@comcast.net> wrote:
Hi,
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.
What program are you using to access your SQLite database? Are you using
the command-line shell that comes with SQLite, a program you wrote
yourself, or some third-party program?
Since I've built my entire database in sqlite3, I'd much rather keep it.
Is there anybody that is knowledgable about Hebrew support? I'm just
learning Hebrew myself, to I'm no guru.
Any help or suggestions will be appreciated.
D.E.
--
"Any society that would give up a little liberty to gain
a little security will deserve neither and lose both."
Benjamin Franklin
______________________________**_________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
--
"Any society that would give up a little liberty to gain
a little security will deserve neither and lose both."
Benjamin Franklin
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
