typo:
*I am summarizing options to support unicode* case-insensitive*:
On Sat, Oct 25, 2014 at 10:34 AM, dd wrote:
> I am summarizing options to support unicode case-sensitive:
>
> 1. Richard Hipp: icu ext
> 2. Aleksey Tulinov: https://bitbucket.org/alekseyt/nunicode#markdown-
> header-sqlite3-e
I am summarizing options to support unicode case-sensitive:
1. Richard Hipp: icu ext
2. Aleksey Tulinov: https://bitbucket.org/alekseyt/nunicode#markdown-
header-sqlite3-extension
3. Grey's suggestion: custom collation
Please add in options list if I missed.
I don't have experience in
Thank you.
On Fri, Oct 24, 2014 at 11:24 PM, Constantine Yannakopoulos <
alfasud...@gmail.com> wrote:
> On Fri, Oct 24, 2014 at 9:40 AM, dd wrote:
>
> >
> > >>The SQLite source code includes an "ICU" extension that does these
> > overloads.
> >
> > Will it solve for all charsets if ICU enabled?
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
> Sent: Friday, October 24, 2014 4:45 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] quasi-bug related to locking,and
> attached datab
On 24 Oct 2014, at 10:40pm, dave wrote:
> Later I can try on linux, but I don't have it at my fingertips just now. I
> don't mind trying with other versions of sqlite if you think it's helpful,
> but I suspect it's been there forever.
Not gonna ask for this since you've now given enough info f
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
...
> On 24 Oct 2014, at 9:54pm, dave wrote:
>
> > Can locking be made more clever to know about aux being an alias
> > for main, and effectively translate
On 24 Oct 2014, at 9:54pm, dave wrote:
> Can locking be made more clever to know about aux being an alias
> for main, and effectively translate the query shown to it's functional
> equivalent of:
>insert or replace into main.dest ( name, value ) values ('allow',(select
> value from main.sou
Hi folks;
I may have found a locking-related bug (or not, depending on your
perspective). In my situation, I am using a system where several databases
have been attached, and I am trying to execute a query which hangs in the
busy handler, ultimately because two locks are attempted on the same fi
On Fri, 24 Oct 2014 21:44:50 +0400
dd wrote:
> >>Convert everything to upper (or lower) case brute force.
>Sorry. I am not clear. Can you please elaborate this.
The standard function tolower(3) is locale-dependent. If your locale is
set to match the data's single-byte encoding,
On Fri, Oct 24, 2014 at 9:40 AM, dd wrote:
>
> >>The SQLite source code includes an "ICU" extension that does these
> overloads.
>
> Will it solve for all charsets if ICU enabled?
>
>
Probably but I cannot tell for sure because I haven't used it. When my
company started using SQLite we didn't k
By "brute force" I just meant specifying each conversion (such as Ö to
ö) individually. In my Tcl code, it is done with a single [string map
...] statement containing all of the conversions. The down side being,
as I mentioned earlier, that each time I run it on a new set of data I
have to chec
On 24/10/14 20:44, dd wrote:
dd,
Any sample/open source avail to custom collation. Will it work for like
queries. Any performance degradation?
You might try nunicode:
https://bitbucket.org/alekseyt/nunicode#markdown-header-sqlite3-extension.
I think COLLATE NU700_NOCASE should do what y
On Fri, Oct 24, 2014 at 1:44 PM, dd wrote:
> Hi,
>
> Any sample/open source avail to custom collation.
http://www.sqlite.org/compile.html#enable_icu
> Will it work for like
> queries.
Yes
> Any performance degradation?
>
Yes. Such is the price of unicode.
--
D. Richard Hipp
d...@sq
Hi,
Any sample/open source avail to custom collation. Will it work for like
queries. Any performance degradation?
>>Convert everything to upper (or lower) case brute force.
Sorry. I am not clear. Can you please elaborate this.
Thanks.
On Fri, Oct 24, 2014 at 9:16 PM, Gerry Snyd
In a vaguely similar situation I wrote a custom collation that converted
accented letters to their non-accented cousins. Since the conversion is
on a case-by-case basis I also had to do a pre-screening that would show
any non-ascii characters that I wasn't converting, so that I could add
them t
Hi,
ö and Ö same character but case different. I dont want to allow to insert
two entries for same data with different case. It works well with ascii
set. How to handle this? any inputs welcome.
$./sqlite3 '/home//sqlite/test/a.db'
SQLite version 3.8.7 2014-10-17 11:24:17
Enter ".help" for us
supermariobros wrote:
> EXPLAIN QUERY PLAN SELECT rowid FROM activity_text_content WHERE
> activity_text_content MATCH 'x' AND rowid>1000 ORDER BY rowid ASC LIMIT 10;
> 0|0|0|SCAN TABLE activity_text_content VIRTUAL TABLE INDEX 4: (~0 rows)
>
> If I understand it correctly it uses indexes properly
Hi,
this is the result of .fullschema *after* i have run ANALYZE
CREATE TABLE "rigdoc"(RdoIdoc INTEGER NOT NULL,RdoCcau TEXT NOT NULL
COLLATE NOCASE,RdoCdep TEXT NOT NULL COLLATE NOCASE,RdoCart TEXT NOT
NULL COLLATE NOCASE,RdoDesc TEXT NOT NULL COLLATE NOCASE,RdoCumi TEXT
NOT NULL COLLATE NOCASE,
On Fri, Oct 24, 2014 at 7:45 AM, Luigi Iemma wrote:
> Hi,
>
> if I do an ANALYZE then works, bat because it changes if I use left instead
> of inner
>
> this is the result of .fullschema
>
Can you send us the ".fullschema" *after* you have run ANALYZE?
--
D. Richard Hipp
d...@sqlite.org
__
Hi
Thanks For quick response
Of course you are right that I can not use row id in the way I used it
above. I guess I wrote it quicker than I thought about it.
However If I use original rowid and LIMIT it should be fine, knowing that
the submited rowid is the rowid of the last element of the previ
Richard Hipp writes:
> In 14 years, you are the first person to ask for them. That tells me that
> probably not many people would use them even if we did put them in.
I've only written one program using sqlite a few years ago, and I had to
make an ugly workaround using UNIONs and LEFT OUTER JOI
Hi,
if I do an ANALYZE then works, bat because it changes if I use left instead
of inner
this is the result of .fullschema
CREATE TABLE "rigdoc"(RdoIdoc INTEGER NOT NULL,RdoCcau TEXT NOT NULL
COLLATE NOCASE,RdoCdep TEXT NOT NULL COLLATE NOCASE,RdoCart TEXT NOT NULL
COLLATE NOCASE,RdoDesc TEXT NO
22 matches
Mail list logo