I apparently successfully compiled the ICU extension with:
gcc -shared icu.c `icu-config --ldflags` -o libSqliteIcu.so
but when I try to load it like this (using the TCL API, linux binary from the
site):
load tclsqlite-3.6.0.so
% sqlite3 db test.db
% db enable_load_extension 1
% db eval
Hello!
В сообщении от Thursday 31 July 2008 15:16:55 Christophe Leske написал(а):
> Hi,
>
> i am in need for a like statement which correctly resolves diacritic
> charcaters.
>
> I found this posting on the net:
> http://www.mail-archive.com/sqlite-users@sqlite.org/msg35613.html
>
> So i looked
Christophe Leske <[EMAIL PROTECTED]> writes:
> i am in need for a like statement which correctly
> resolves diacritic charcaters.
> can anyone help? I am on Windows XP and ideally
> looking for a precompiled version of the DLL.
Don't know about any Download-Links for precompiled
>
> You probably want
>
> x.first_name like substr(y.first_name, 1,2) || '%'
>
> or
>
> substr(x.first_name, 1, 2) = substr(y.first_name, 1, 2)
>
> Igor Tandetnik
>
Igor, Peter, Thanks very much for your help.
This
"Brandon, Nicholas (UK)"
<[EMAIL PROTECTED]> wrote in
message
news:[EMAIL PROTECTED]
> I have a table with first_name and a last_name column. I would like to
> find similar duplicates by finding the same last_name and matching the
> first two characters of the first name. Therefore if the table
On Thu, Jul 31, 2008 at 12:54:02PM +0100, Brandon, Nicholas (UK) wrote:
> select * from current as x, current as y where x.last_name = y.last_name
> and x.ind_id != y.ind_id and x.first_name like substr(y.first_name, 0,2)
>
> In my english I was trying to write "match where the first name of x
>
This should be simple but my brains not functioning. So I would
appreciate some help from the SQL masters...
I have a table with first_name and a last_name column. I would like to
find similar duplicates by finding the same last_name and matching the
first two characters of the first name.
Hi,
i am in need for a like statement which correctly resolves diacritic
charcaters.
I found this posting on the net:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg35613.html
So i looked for the ICU extension, downloaded it and tried to compile it.
Surprise, it also wants some ICU
Hello!
В сообщении от Thursday 31 July 2008 12:10:54 Petr Vanek написал(а):
> > I gave it a try, and it seems as if SQLiteman can´t handle extensions
> > for databases, is this right?
>
> not yet unfortunately. But it's requested already.
>
> http://sqliteman.com/bugtracker/view.php?id=136
>
>
> I gave it a try, and it seems as if SQLiteman can´t handle extensions
> for databases, is this right?
not yet unfortunately. But it's requested already.
http://sqliteman.com/bugtracker/view.php?id=136
can you provide any extensions for testing, please?
petr
10 matches
Mail list logo