sqlite and hebrew variations

SELECT * FROM table WHERE word = "רֵאשִׁית" would return results that contain given word, but same words ( בְּרֵאשִׁית ,בראשית ,רֵאשִׁית) that are written using different hebrew variants are ignored.

Is there a way to ignore the difference between the variants in order to have them all in the result returned?

Answers


The algorithm used to compare strings is called a collation.

To allow using custom collation rules, you have to use SQLite's C API to register your own collation function: http://www.sqlite.org/c3ref/create_collation.html

If you're on Android: the OS registers a collation named UNICODE, which implements the Unicode Collation Algorithm, which may or may not do what you want.

Other SQLite installations may have been compiled with the ICU extension.


Need Your Help

System.Net.WebClient not throwing error during UploadString to invalid url?

c# .net webclient

Given this code, I expected an exception to happen, but System.Net.WebClient.UploadString returns an empty string into result.

How to code for moving/removing an mvc route “forever”

asp.net asp.net-mvc http redirect seo

I have a few pages on a website that have recently been moved (to another mvc route) and some have been removed. How should such a change be handled, in terms of being nice to search engines (and my

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.