Re: [sqlite] ICU collation

On Tue, Dec 22, 2009 at 06:56:29AM +, Simon Slavin wrote: > On 22 Dec 2009, at 4:55am, Sylvain Pointeau wrote: > > How is [this?] supposed to work ICU in SQLite? > > I hope someone can answer your question. I don't know enough. I don't know about ICU but, really this is something that needs

Re: [sqlite] ICU collation

On 22 Dec 2009, at 4:55am, Sylvain Pointeau wrote: > 04: flusse > 05: fluße > 36 42 54 50 50 34 00 This is a German spelling reform matter. The system is making sure that text typed before the spelling reform matches text typed after the spelling reform. Technically speaking, whichever

Re: [sqlite] ICU collation

Hi, thanks for your help, I also found that L1 = Base Letters worked as I expected ... *Collated* 09: fluasse 36 42 54 2c 50 50 34 00 06: flüße 07: flüsse 08: fluesse 36 42 54 34 50 50 34 00 02: Fluße 03: Flusse 04: flusse 05: fluße 36 42 54 50 50 34 00 01: Fuße 36 54 50 50 34 00 How is

Re: [sqlite] ICU collation

Olaf Schmidt wrote: >> As I see it - one has different (fine-tuning) options for >> ICU, which work "on top" of a choosen "base-setting". >> If I set the first entry (all others remain at their defaults) to: >> L1 = Base Letters >> >> then ICU behaves IMO in the way the OP wants

Re: [sqlite] ICU collation

"Igor Tandetnik" schrieb im Newsbeitrag news:hgom0b$u0...@ger.gmane.org... Sylvain Pointeau wrote: > > How does sqlite handle ICU, I don't understand? > > is it used only for the sort order? > No, the collation is used both for sorting and for

Re: [sqlite] ICU collation

Sylvain Pointeau wrote: > How does sqlite handle ICU, I don't understand? > is it used only for the sort order? No, the collation is used both for sorting and for equality check. However, ICU doesn't actually treat 'ä' as equal to 'ae'. You can see for yourself

Re: [sqlite] ICU collation

How does sqlite handle ICU, I don't understand? is it used only for the sort order? Best regards, Sylvain On Mon, Dec 21, 2009 at 12:41 AM, Sylvain Pointeau < sylvain.point...@gmail.com> wrote: > it is written here > http://userguide.icu-project.org/collation >

[sqlite] AUTO: Bret Patterson/Austin/IBM is out of the office (returning 01/04/2010)

I am out of the office until 01/04/2010. I'm out of the office but checking email once or twice a day and will respond to any high importance issues as quickly as possible. Note: This is an automated response to your message "sqlite-users Digest, Vol 24, Issue 11" sent on 12/11/09 5:00:01.

Re: [sqlite] multiple threads, multiple databases, and batch mode

On Dec 21, 2009, at 12:40 PM, Chris Parker wrote: > We have an application that attaches 2 java threads that establish > their > own connection to SQLite databases. While one is running (loading a > table), the other thread attempts an ATTACH DATABASE command and > receives a "cannot ATTACH

[sqlite] multiple threads, multiple databases, and batch mode

We have an application that attaches 2 java threads that establish their own connection to SQLite databases. While one is running (loading a table), the other thread attempts an ATTACH DATABASE command and receives a "cannot ATTACH database within transactions". A transaction has been started in

Re: [sqlite] SQLitedb problem

On 21 Dec 2009, at 3:12pm, Jay A. Kreibich wrote: > Make a copy of the database file. Run the VACUUM command on the copy. > If the data is gone from the raw file dump, it has already been deleted > from the database structure. Alternatively you could use the command-line tool included with

Re: [sqlite] IEE754-2008 decimal32, decimal64 datatypes and SQLite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Simon Slavin wrote: > Does C use proper IEE755 maths when you do mundane things like add two floats > together ? I assumed it compiled down to simple CPU calls which were faster > than IEE755 but not as clever with things like NaN. The vast

Re: [sqlite] SQLitedb problem

On Mon, Dec 21, 2009 at 10:59:10AM +, Othman Guessous scratched on the wall: > Hello, > > I have a problem with a sqlitedb file. So there is some data in this > sqlitedb file (on notepad or pspad we can found easily these data) but they > don't appear on a sqlite application browser (i use

[sqlite] SQLitedb problem

Hello, I have a problem with a sqlitedb file. So there is some data in this sqlitedb file (on notepad or pspad we can found easily these data) but they don't appear on a sqlite application browser (i use SQLite Database Browser 2.0 b1)...it seems that these data are ignored. Then how can i fix

Re: [sqlite] IEE754-2008 decimal32, decimal64 datatypes and SQLite

Simon Slavin wrote: > Showing my ignorance of C here. Does C use proper IEE755 maths when you do > mundane things like add two floats together ? You probably mean IEEE 754. The C standard doesn't mandate the use of IEEE 754 floating point arithmetic. The implementation may choose to implement

[sqlite] ANN: SQLite PHP Generator 9.12 released

Hi! SQL Maestro Group announces the release of SQLite PHP Generator, a GUI frontend that allows you to generate a full set of PHP scripts for SQLite tables, views and queries for the further working with these objects through the web. http://www.sqlmaestro.com/products/sqlite/phpgenerator/

Re: [sqlite] Corrupted database (image is malformed): always the same size

On 21 Dec 2009, at 8:00am, Gianandrea Gobbo wrote: > At this stage, I cannot think of an applicative bug that leads to this > kind of corruption, where the database results always in the same size. The only time I ever saw a number of files all truncated to the same length, the fault was in

Re: [sqlite] Corrupted database (image is malformed): always the same size

Max Vlasov ha scritto: > On Fri, Dec 18, 2009 at 6:27 PM, Gianandrea Gobbo wrote: > > Gianandrea, I once had an experience with fixing a modified code that led to > database disk image malformation. If you can reproduce the bug with a > comparatively few number of steps, I'd