On 14/10/14 17:02, Kevin Benson wrote:
https://bitbucket.org/alekseyt/nunicode/downloads/libnusqlite3-1.4-4a0e4773-win32.zip
<---
404 response code
Thank you, fixed now.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/c
On Tue, Oct 14, 2014 at 4:37 AM, Aleksey Tulinov
wrote:
> Hello,
>
> I'm glad to announce that nunicode SQLite extension was updated to support
> Unicode-conformant case folding and was improved on performance of every
> component provided to SQLite.
>
> You can read about and download this exten
Hello,
I'm glad to announce that nunicode SQLite extension was updated to
support Unicode 7.0.0 character set. It also implements LIKE operation
which is faster compared to previous releases.
This extension provides the following Unicode-aware components:
- upper(X)
- lower(X)
- X LIKE Y ESC
Hey,
According to previous discussion in this mailing list, i've updated
nunicode SQLite extension not to override default NOCASE collation due
to possible issues with database indexing.
Version 1.2.1 removes nunicode-specific NOCASE and NUNICODE collations
and introduces NU630 and NU630_NOC
Very nice! Thanks for sharing, Aleksey.
2013/11/9 Aleksey Tulinov
> On 11/04/2013 11:50 AM, Aleksey Tulinov wrote:
>
> Hey,
>
>
> As you can see, this is truly full Unicode collation and case mapping
>> with untailored special casing. Extension provides the following functions,
>> statements a
On 11/04/2013 11:50 AM, Aleksey Tulinov wrote:
Hey,
As you can see, this is truly full Unicode collation and case mapping
with untailored special casing. Extension provides the following
functions, statements and collations:
I've updated extension, examples and documentation, now it's easier
On Tue, Nov 17, 2009 at 09:31:46PM -0500, Tim Romano wrote:
> but if ORDER BY is
> relying on an index for ordering, then flip() can have negative
> effects.
>
>
> Substr() could have negative effects on ordering too. That is a red
> herring. Flip() is merely a function that reverses the or
but if ORDER BY is
relying on an index for ordering, then flip() can have negative effects.
Substr() could have negative effects on ordering too. That is a red
herring. Flip() is merely a function that reverses the order of
codepoints "as found" without knowing anything about what those
co
Tim,
>For those who are insisting on Unicode graphemic codepoint-combination
>intelligence: why can't we have a function that simply reverses the
>order of the codepoints, and is blissfully ignorant about what those
>individual codepoints or codepoint-combinations might signify as
>graphemes in
For those who are insisting on Unicode graphemic codepoint-combination
intelligence: why can't we have a function that simply reverses the
order of the codepoints, and is blissfully ignorant about what those
individual codepoints or codepoint-combinations might signify as
graphemes in a writin
On Tue, Nov 17, 2009 at 05:15:16PM -0500, Igor Tandetnik wrote:
> Nicolas Williams wrote:
> > This is no longer true, either of 'ch' nor 'll'.
>
> There is a number of contractions in Hungarian that are still very
> much in use, but I can't recall them off the top of my head the way I
> can 'ch'
On 17 Nov 2009, at 10:05pm, Beau Wilkinson wrote:
> I think a better approach (to the design of Unicode) would have been for
> Spanish and German (for instance) to share absolutely nothing in the encoding
> standards. Each language ought to have its own little span of letters,
> immortalized i
esday, November 17, 2009 1:01 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Unicode support
Simon Slavin wrote:
> On 17 Nov 2009, at 6:37pm, Igor Tandetnik wrote:
>
>> Simon Slavin wrote:
>>> First split the string into characters, then reassemble them in
>>> rever
Nicolas Williams wrote:
> On Tue, Nov 17, 2009 at 02:01:55PM -0500, Igor Tandetnik wrote:
>> This would mean that the result of the hypothetical flip() function
>> would be locale-dependent. E.g. in Spanish Traditional sort, a
>> combination 'ch' sorts as if it were a single letter between 'c' and
fuse to implement things and still look smart in so refusing. I
suggest that this a very detrimental pattern, though.
________
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] On
Behalf Of Igor Tandetnik [itandet...@mvps.org]
Sent: Tuesda
On Tue, Nov 17, 2009 at 02:01:55PM -0500, Igor Tandetnik wrote:
> This would mean that the result of the hypothetical flip() function
> would be locale-dependent. E.g. in Spanish Traditional sort, a
> combination 'ch' sorts as if it were a single letter between 'c' and
> 'd', forming a single sort
Simon Slavin wrote:
> On 17 Nov 2009, at 6:37pm, Igor Tandetnik wrote:
>
>> Simon Slavin wrote:
>>> First split the string into characters, then reassemble them in
>>> reverse order.
>>
>> The problem is, in Unicode it's not quite clear what constitutes a
>> "character". Are we talking about co
Thankyou all for the quick replies.
Best Regards,
A.Sreedhar.
-Original Message-
From: Trevor Talbot [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 12, 2007 5:08 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Unicode support for Sqlite?
On 12/12/07, Sreedhar.a <[EM
On 12/12/07, Sreedhar.a <[EMAIL PROTECTED]> wrote:
> I am using the sqlite to store the metadata of audio files.
> Is it possible to store the metadata in unicode character format in sqlite.
Yes; SQLite assumes all TEXT type data in the database is Unicode. You
can work with it in UTF-8 with the
utf-8 and utf-16 ARE unicode formats. But there are some things that
sqlite does not handle without the ICU extension.
The ICU extension extends SQLite with the following functionallity:
1.1 SQL Scalars upper() and lower()
1.2 Unicode Aware LIKE Operator
1.3 ICU Collation
: sqlite-users@sqlite.org
Subject: Re: [sqlite] Unicode support for Sqlite?
On 12/12/07, Sreedhar.a <[EMAIL PROTECTED]> wrote:
> Does Sqlite support unicode?
> I have seen that it supports utf-8 and utf-16.
> I want to know whether it supports unicode character formats.
Unicode is a
On 12/12/07, Sreedhar.a <[EMAIL PROTECTED]> wrote:
> Does Sqlite support unicode?
> I have seen that it supports utf-8 and utf-16.
> I want to know whether it supports unicode character formats.
Unicode is a very large and complex topic, so that question is way too
vague to answer. Can you provid
Am 04.08.2006 um 19:23 schrieb Cory Nelson:
I was not talking about sorting in my post - I've had simple = index
comparisons fail in UTF-8.
I'm pretty sure you can get the same kind of 'failure' when using
UTF-16, e.g. when comparing decomposed against composed forms of
unicode strings. S
On Fri, Aug 04, 2006 at 10:02:58PM -0700, Cory Nelson wrote:
> On 8/4/06, Trevor Talbot <[EMAIL PROTECTED]> wrote:
> >On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
> >
> >> But, since you brought it up - I have no expectations of SQLite
> >> integrating a full Unicode locale library, however it
On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
On 8/4/06, Trevor Talbot <[EMAIL PROTECTED]> wrote:
> On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
>
> > But, since you brought it up - I have no expectations of SQLite
> > integrating a full Unicode locale library, however it would be a grea
On 8/4/06, Trevor Talbot <[EMAIL PROTECTED]> wrote:
On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
> But, since you brought it up - I have no expectations of SQLite
> integrating a full Unicode locale library, however it would be a great
> improvement if it would respect the current locale an
On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
But, since you brought it up - I have no expectations of SQLite
integrating a full Unicode locale library, however it would be a great
improvement if it would respect the current locale and use wcs*
functions when available, or at least order by
On 8/5/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
On 8/4/06, Nuno Lucas <[EMAIL PROTECTED]> wrote:
> On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
> > IE, using memcmp() to compare strings. I've been bitten by this
> > before, with SQLite producing unexpected results when using UTF-8.
> > Us
On 8/4/06, Nuno Lucas <[EMAIL PROTECTED]> wrote:
On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
> IE, using memcmp() to compare strings. I've been bitten by this
> before, with SQLite producing unexpected results when using UTF-8.
> Using UTF-16 has worked more reliably in my experience.
SQL
On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
IE, using memcmp() to compare strings. I've been bitten by this
before, with SQLite producing unexpected results when using UTF-8.
Using UTF-16 has worked more reliably in my experience.
SQLite only knows how to sort ASCII, so memcmp does that
On 8/4/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"Cory Nelson" <[EMAIL PROTECTED]> wrote:
> On 8/3/06, RohitPatel <[EMAIL PROTECTED]> wrote:
>
> I recommend using utf-16 in the database - sqlite doesn't fully
> support utf-8, and some things may give unexpected results if you use
> it.
"Cory Nelson" <[EMAIL PROTECTED]> wrote:
> On 8/3/06, RohitPatel <[EMAIL PROTECTED]> wrote:
>
> I recommend using utf-16 in the database - sqlite doesn't fully
> support utf-8, and some things may give unexpected results if you use
> it.
>
Oh really? What exactly is missing from SQLite's UT
e 09, 2005 12:12 AM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] UNICODE Support
But what about the SQLite Function's parameters whose data type is LPSTR
?
Let me know the details to support wide char ?
Regards,
Ajay Sonawane
-Original Message-
From: Martin Engelschalk
e.org
Subject: Re: [sqlite] UNICODE Support
Hi,
See http://www.sqlite.org/pragma.html, search for 'PRAGMA encoding'
/Martin
Ajay schrieb:
>Hello there,
>
>Does SQLite support UNICODE? Can I store some Arabic or Chinese text in
>database?
>
>If it does not support UNI
Hi,
See http://www.sqlite.org/pragma.html, search for 'PRAGMA encoding'
/Martin
Ajay schrieb:
Hello there,
Does SQLite support UNICODE? Can I store some Arabic or Chinese text in
database?
If it does not support UNICODE, Is there any workaround for that?
Regards,
Ajay Sonawane
35 matches
Mail list logo
