>when Database tries to create tables, getting the below error:
>"table insert failed for eventLog" any idea what is the reason, also I
>have
>these errors when I run manually, I gets these:
Uh! To help you in an efficient manner, it's obvious we absolutely
need an octal core dump of your
>The execution time of the first time I run my query varies wildly, I
>dunno why.
Probably due to an empty or dirty cache. That's fairly common with
cache inclined applications, subsystems or OSes. The second time, most
of what's needed is found in cache with much less variability.
>The porter stemmer, by its very nature, is not intended to work for
>non-english text
You should read the Snowball site about this: http://snowball.tartarus.org/
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hello Simon,
>This has the advantage of removing the chance of a name-space collision.
That's true as well: it is an added free bonus. But honestly I would
say that for such transient usage a random generated name is fairly
unlikely to cause real-world problem.
select hex(randomblob(16));
Hi Tim,
>I am also somewhat in the dark about concurrency issues (if any) in a
>webservice scenario:
>-- Do TEMP tables have database-connection-scope so that there is no
>need to name the TEMP table uniquely? Does the table get deleted
>automatically when the connection is closed if the
Welcome to the SQLite list.
>Can I add a column name containing a dash "-" and if yes, how would I
>do that?
Make this
create table test([column-1] varchar(255));
or
create table test("column-1" varchar(255));
Both work
___
sqlite-users
>No, it fails because 20 != '20'
And also possibly because
Date LIKE "2009%"
should be
Date LIKE '2009%'
everywhere it appears.
___
sqlite-users mailing list
sqlite-users@sqlite.org
>I'm having trouble sorting the following data:
>
>point_number - VARCHAR(10)
I've developped an SQLite extension including a very similar collation:
it sorts the (integral) prefix first and, in case of a draw, orders
based on the Unicode suffix.
It currently doesn't cope with floating-point
Hi Dan,
> > I've finally implemented the backup API and it works like a charm
> > except on an important point.
> > The example given on the site clearly says:
> >
> > "If another thread writes to database connection pDb while this
> > function is sleeping, then the backup database (database
I've finally implemented the backup API and it works like a charm
except on an important point.
The example given on the site clearly says:
"If another thread writes to database connection pDb while this
function is sleeping, then the backup database (database connection
pFile) is
Hi Robert,
>For example, if I could store a graph in a sqlite database, I'd like
>to query the database to know if the graph contains a Eulerian
>path[1].
I may be driven by a misleading uneducated impression, but given the
nature of most graph-related algorithms --I see the search for Eulerian
>create table cities
>(
>id integer primary key not null,
>name text not null
>);
>
>create table people
>(
>id integer primary key not null,
>name text not null,
>cities_id integer not null,
>foreign key(cities_id) references cities(id)
>);
>
>insert into cities(name) values('Campos');
>insert
Hi,
>I am trying to migrate to Sqlite3.6.21. I visited the Sqlite site and
>downloaded the compiled file. I'm surprised in verifying that the zip
>only had the executable. I hoped to find also the DLL.
I bet you downloaded this: http://www.sqlite.org/sqlite-3_6_21.zip
This is the CLI, he
> I am inserting data into asset table as m/d/ HH:MM:SS t format
>Ex: INSERT INTO ASSET (WARRANTSTDATE) VALUES ('12/22/2009 12:01:00 AM')
>Ex: INSERT INTO ASSET (WARRANTSTDATE) VALUES ('9/22/2009 12:01:00 AM')
>but my select query failed : No record found
Not surprising: you made it very
>I believe there is a bug here.
Yes, in I my own head!
We simply need to take care of integral values.
The correct rounding down at 3rd decimal places using SQLite can
be done so:
case
when cast(myValue as text) <> round(myValue) then
round(myValue - 0.0005, 3)
else
[ I apologize if this appears twice on the list ]
Hi,
At 00:11 13/12/2009, you wrote:
>Sir any ida how can value rounddown floor have done
>
>if not possible i have make small code
>i requard make function please say how can add
>
>i send you my rounddown funtion
>
>please
>Cose Exmaple :
Hi,
At 00:11 13/12/2009, you wrote:
>Sir any ida how can value rounddown floor have done
>
>if not possible i have make small code
>i requard make function please say how can add
>
>i send you my rounddown funtion
>
>please
>Cose Exmaple :
>value=10.666
>decimal=1
>Create roundd{value,decimal){
>Something like (one line, wrapped by email):
>
>echo "INSERT INTO t1 (id,pic) VALUES (1,X'$(od -A n -t x1
>picture.gif | tr -d '\r\n\t\ ')')" | sqlite3 mydb
>
>(The od utility may be smarter than that, optimization left
>to the OP)
Looks good, you know better than I do. Just checked: od and
Ted,
>Is it the command-line program misinterpreting the CR/LFs?
Unfortunately, any command-line tool will interpret control characters
at their face value when they are fed directly.
With no ad hoc program doing it for you, the solution, as I've
discussed at length before and even if it is
>Could you please give me a step by step on how to do that? Not via a
>small program written in a programming language, but only via the
>sqlite3 shell, as both you and I agree that was the implied intent of
>the OP's question.
Sorry, I'm no vxWorks, Unix, Linux, MacOS, Windows, AS400, Symbian,
Hi Puneet,
>Yes, that seems like a reasonable interpretation of the OP's question,
>one I also understood. One thing I don't understand though,
>Jean-Christophe, even though one can enter base64 encoded "images"
>into the db via the sqlite shell, how does one create the base64
>encoded images?
>What is "programatically"
>
>How, in any meaningful way, is this different than running a shell
>command (program of an extremely brief size)?
I took the OP's phrasing to mean that he needed a way to do it with
e.g. command-line available programs, but in any case without having to
use a
>hi , im using sqlite3 in debain
>
>i want to check the first character should not be an special character.
>[by before insert trigger]
>how to do it?
>i thought of using ascii function but i didnt find in sqlite.
No such function is part of the SQLite core. But I wrote an extension
offering
>You are correct. You proved that it is possible.
>
>part 2: What are the usual and convenient ways of inserting images
>into a sqlite db? answer: Programmatically.
I certainly don't dispute this, and I added to this effect:
> It may not be the prefered way in most application, but it's
>
> > From what I read, it is necessary to have a programmatic interface to
> > put images into a database. True?
>
>yes, but I am not sure what other kind of interface there could be?
>You can't imagine putting an image into a sqlite db through the
>command line shell application. Of course, you
I'm certainly not a SQlite guru, but
>sqlite> select * from sqlite_master where name = 'dly04';
>table|dly04|dly04|1042384|CREATE TABLE dly04(i_stnid integer,
>national_identifier varchar2(7),
> local_year integer, local_month integer, local_day integer, etc, etc
>
> I then imported data
Gidday Tim,
>I will look further into this approach:
>
> select sqlite3_load_extension('mylibrary', 'entrypoint');
>
>to see if Adobe's security permits it. However, the Adobe FlashBuilder
>database application developer must confront this uncertainty: Adobe has
>been unresponsive to questions
Hi Tim,
> ... where myTextColumnUsingDefaultBinaryCollation like 'foo%'
Did you try
... where myTextColumnUsingDefaultBinaryCollation glob 'foo*'
GLOB is hardcoded as case-sensitive and more likely a candidate to
using index. Just check it.
>2. In Adobe, one is not able to load a
>Last minute comments on the pending release of SQLite 3.6.21 are
>welcomed.
Thank you for your continued efforts.
Can you consider making sqlite3_auto_extension and
sqlite3_reset_auto_extension available into the API structure so that
they can both be invoked from within an extension without
>PRAGMA set case_sensitive_like =1
This should be:
PRAGMA case_sensitive_like = 1
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>Now I want to make query on employee table which gives the result having
>names start between 'D' and 'M', so probable I'll do something " SELECT *
>FROM employee WHERE name BETWEEN 'd%' AND 'n%' ". But this is very
>specific
>if I know the characters. I want to avoid using the character and
When the argument to sqlite3_value_type() is either a litteral or a
result of some scalar function, can we rely on testing for the 5
datatypes reliably?
I understand that when the argument comes from a column, then the type
returned by sqlite3_value_type() is the column type. But litterals
Hi Igor,
>The blob (x'41' is a blob literal) is expected to contain a UTF-8
>sequence, I believe.
That means the user enters the hex UTF-8 (or 16 depending on base
encoding) representation of the character. E.g.:
select cast(x'c389' as text);
É
Something like:
select chrw(x'c9');
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
>So, for example, if one wanted to find all rows where myNormalColumn
>ENDS WITH 'fi c d', one could search myFlippedColumn like this:
>
>select * from LEXICON where myFlippedColumn LIKE 'd c if%' --
>allows index use
Make this
select * from LEXICON where myFlippedColumn LIKE flip('fi c
>Unfortunately I cannot modify the query... it is supplied by an user.
Well, what about upgrading the user?
Sorry coul'd resist ... I'm already out!
___
sqlite-users mailing list
sqlite-users@sqlite.org
>Now that I have a working tool to convert from Access .mdb to sqlitedb
>files, I need one for dBASE .dbf files. Or, a conversion to .csv will
>work,
>too. Needs to run on linux, of course.
>
>My Google searches turned up a bunch of tools for the Windows
> platforms,
>supposedly free
Hi,
> >
> > Maybe many others have asked this question, so I will say sorry if
> > that's true.
> > I have a program which uses threads, when writing to (sometime even
> > reading
> > from) SQLite, I always got the error of database is locked.
> > I think since SQLite is a file db, so it get
>I think that my problem is in using LIKE expression for non-ascii strings.
>Database encode is UTF-8. When table data in the "base" column (see my
>first
>message for structure) consists of english symbols (ascii) LIKE works
>correct, but when I'm trying to execute it on strings consists of
>Third, my oriiginal inquiry:
>
>SELECT *
> FROM fm
> WHERE name LIKE '%Juiian%'
> OR info LIKE '%Julian%'
> ORDER by name;
>
>returned the (correct) 6 rows.
BTW, if you or anyone else need a fuzzy compare function I have one
that can help. It works with internally Unicode-unaccented
>Hello! Please, help me if you have a time for this. I have an sqlite
>database
>table:
>CREATE TABLE lemma (
> id INTEGER PRIMARY KEY,
> base TEXT,
> preflex_id INTEGER,
> type_ancode TEXT,
> prefix_id INTEGER
>)
>In the "base" column I store a string which I need to compare with
>I just don't want anyone saying "but
>this one dude told me to replace all my structs with SQLite memory
>tables."
Indeed that wouldn't be very clever SQLite promotion!
>I think the best plan in this case would be to get a real language
But, surprisingly this thing is a real language, with
>Nice Freudian slip!
Again rotfl, when you know that slip is French word for men underwear...
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>I think "worth" should be more accurate.
Yes, rotfl! I realize this while hitting Send and didn't dare one more
post.
You know, I'm a victim of rogue cosmic rays and badly need one of those
stock ECC brains. Sorry for my French accent btw!
___
You read 'worse' instead of 'worst', of course!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi John,
>I wouldn't use SQLite for most in memory data that never needs to be
>stored on disk
Even this depends entirely on your context. Of course if only a simple
lookup in a table is more or less all you ever need, there is little
point in SQLite. But if or when your requirements get
>I would like to do a where on a text field and check if the values have
>non-numeric characters,
>which is in this case is anything other than 1,2,3,4,5,6,7,8,9,0 or a
>space
>character.
>Is this possible without using a UDF or a very long OR construction?
select * from mytable where mycol
´¯¯¯
>In your specific example you could simply define a custom "LIKE"
>function, and LIKE could become Unicode aware without any goofy new
>operators.
`---
Yes of course, but I'm doing so to keep the possibility to use the
native operator as well.
>Thanks for the link. That clarifies things a lot. So, for the OP, if you
>are targeting Win2k, it would be a good idea to use UCS-2, not UTF-16,
>with any wide API calls. XP and above should (according to Kaplan and
>Chen) support UTF-16 for API calls.
W2k is clearly something of the past.
Hi John,
>Microsoft never seems to clearly identify whether the wide APIs should
>be given UTF-16 or UCS-2. Their guide on internationalization would seem
>to suggest that UCS-2 must be used, however, there is some reason to
>believe that perhaps UTF-16 is handled correctly as well. Couldn't
Hi,
´¯¯¯
>Despite of that, I'm aware that I have some more that pure US-ASCII in
>the
>blob objects, in fact I'm near your situation because used the Spanish
>languaje and have 8-bit extended ASCII with some special
>characters -accented characters and so-.
>
>So the question is Yes, I have
Hi,
Please, follow Igor advices, he is right.
>[1] Read the actual textual data with sqlite3_column_blob()
Which you can directly convert to TEXT if, as you say, you entered only
7-bit ASCII or UTF-8 compliant data.
>[2] Assuming the system code page matches the one used when the data was
>My main point is that you can't take the UTF-16 string and safely supply
>it to APIs which want UCS-2 encoded text, such as Win32 APIs (including
>things like SetWindowText()). Odds are that the only library you are
>using which supports UTF-16 is SQLite. You should always be converting
>the
>[1] Supposing some textual data already inserted as UTF-8 (default
>mode) in
>a dBase, and a connection opened with sqlite3_open(): Does a
>sqlite3_column_text16 retrieves a correct UTF-16 content? Is to say, do
>SQLite the convertion internally?
>
>[2] Assuming the previous -or a UTF-16
Nico, Igor,
You're both right to point out that using SQLite would result in
non-UTF-* compliant data producing unexpected results. There is still
the possibility to store such data as blobs.
Sorry for confusion.
___
sqlite-users mailing list
Ted,
>I didn't insert it. I 'inherited' it from a (mercifully nameless)
>predecessor.
>I want to put this data into a database to make it easily accessible
I'm no SQLite guru (really NO), but here is my 2 cent advice.
First decide or determine what is (or shall be) your database
encoding.
Hi Igor,
>"Temporary foreign keys"? I can't fathom what this term could possibly
>mean.
>
>Your question makes no sense to me, sorry. What problem are you really
>trying to solve?
Sorry, problem solved (outside SQLite).
I noticed that after trying a DBM application I got errors saying that
Dear SQLiters,
I'm almost sure the answer is "No" but I'd rather ask the question anyway.
Is there _any_ situation where the v3.6.19 stock SQLite3 would create
_by itself_ temporary foreign keys not explicitely created by the user,
either or both on the referencing or on the referenced table?
Hi Rob,
>Perhaps this might lead you in the right direction Jean-Christophe ...
>
>#include
Thank you for your answer.
The va_* construct isn't portable, AFAIK. Various compilers (headers,
libraries) may (and did) implement it in different and potentially
incompatible ways.
Since in my
Roger,
Thank you for your answer. I knew from old days that va_* things are
very fragile (not only from the portability point of view).
In the "duct tape programming" situation where I currently am, the best
I can came up with is by fixing the max # of arguments to 32 and using
a _ugly_
I feel the need to wrap an SQLite printf-like function into a scalar
function.
I wish to use it as in:
select printf(format_string, list of arguments);
My question is slightly off topic but there are experienced users here
who have probably done it before.
In the scalar function
>You are trying really hard to overthink things :-)
I simply found version c-1) in a widely spread extension and was
surprised by this way of doing the return, unduly complicated and
inefficient in my poor understanding, hence the question.
___
Hi,
The following details about text/blobs returns from scalar functions
are unclear to me and I prefer doing things right.
a) is it allowable for a scalar function to modify (in place) an input
argument
and return a pointer to modified argument with
sqlite3_result_text? If yes,
what
Andy,
>Hwever, what I want to do is seach for all of these varients too, i.e. so
>that if I search for e that I get all of the e and accented e' etc, is
>this
>possble using something like the collation, or do I need to specify all of
>them individually?
I'm about to release the beta of an
´¯¯¯
>So if a SELECT is in progress, other SELECT commands can be allowed to
>proceed without problems. But no INSERT or UPDATE can be allowed until
>the SELECT is finished. Hence you will sometimes get a lock on the
>write.
>
>How you deal with this, I don't know. Random wait-and-try-again ?
The 3.6.18 sqlite3.exe CLI produces the same problem: the internal
functions below can't be overloaded and trying to do so returns 5.
System is XP Pro x86 SP3.
What can I try next ?
>I see that sqlite3.dll is returning 5 == SQLITE_BUSY for the following
>functions:
>
>upper UTF-8
If I set a breakpoint on this:
rc = sqlite3_create_function(db, p->zName, p->nArg, p->enc,
p->pContext, p->xFunc, 0, 0);
I see that sqlite3.dll is returning 5 == SQLITE_BUSY for the following
functions:
upper UTF-8
lower UTF-8
like 2-arg UTF-8
like 3-arg UTF-8
Update: the problem is in the function registration.
I tried to comment out the UTF-16 registration and the really weird
thing is that using the following code, only GLOB with 3 arguments gets
actually registered (along with all 1-arg string functions and the two
collations).
There must be
Hi Pavel,
>I believe you need to show us your sql query. Maybe something in it
>forces SQLite to use UTF-16 version of the function.
Ummm, I don't kno where the problem is, but _any_ simple select will do
(for me), e.g.:
An UTF-8 base...
CREATE TABLE "PaysISO" (
"Nom_Iso" CHAR(43),
Thank you for your fast answer.
>I'm surprised by this too. In fact, I cannot reproduce it.
I'm using the 3.6.18 Windows dll downloaded direct from the site.
I just re-checked that.
___
sqlite-users mailing list
sqlite-users@sqlite.org
I'm surprised that if I register overloading functions for LIKE or GLOB
in both UTF-8 and UTF-16, only the UTF-16 version is called despite the
fact that the database is UTF-8.
I don't see the same behavior with the other scalar functions (lower,
upper), which call the UTF-8 version as
´¯¯¯
>So what am I missing?
`---
The word 'Euclidean'. Stop dividing just before the result gets
fractional and you're home.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
´¯¯¯
>SQLite tolerates this violation by picking the first
>column from the first row as the value of such an expression. There is
>no n-tuple here.
`---
That explains it very clearly now. Point taken.
Thanks.
___
sqlite-users mailing list
> > INSERT INTO t (a, b, c, d) VALUES ('aa', 'bb', (SELECT c, d FROM t
> > WHERE ));
> > with guaranteed to select exactly one row.
>
>I don't know of any DBMS where this would be valid.
It seems so.
>INSERT INTO t(a, b, c, d)
>SELECT 'aa', 'bb', c, d FROM t WHERE ;
My mistake: I had
Hi all,
I've been surprised that the following syntax doesn't work and returns
"3 values for 4 columns" diagnose message. I'm just asking by curiosity.
INSERT INTO t (a, b, c, d) VALUES ('aa', 'bb', (SELECT c, d FROM t
WHERE ));
with guaranteed to select exactly one row.
I thought
Pavel,
>My 2 cents here is: sometimes bigger and more complicated code runs a
>whole lot faster than simple one if the speed is a real concern of
>course...
Indeed you're right in the general case.
In fact it wasn't at all what I really meant. My problem currently is
to have applications
Igor,
´¯¯¯
>It seems fairly easy to me to
>implement the kind of collation you describe using only a fixed amount
>of extra memory.
`---
I didn't say it was impossible. Just that in this case, the code gets
slowed down in convoluted loops everywhere. Also I feel that clear,
straightforward
Roger,
´¯¯¯
>There is now a ticket for this issue:
`---
Thanks, not high priority but useful someday.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Igor,
>Can't you preallocate sufficient memory at the time the collation is
>created?
Unfornately I can't do that: it would mean I place a maximum size on a
work space allocated at creation for manipulating user strings, which
is taboo in my view.
This is for getting unaccented copies of
Gidday,
>Building sqliteFirst.obj.
>Building SQLiteFirst.exe.
>POLINK: error: Unresolved external symbol '_sqlite3_open'.
>POLINK: error: Unresolved external symbol '_sqlite3_errmsg'.
>POLINK: error: Unresolved external symbol '_sqlite3_close'.
>POLINK: error: Unresolved external symbol
Oops, let me try again!
>SELECT ALLBUT foo FROM t ...
Typing error! Should be
SELECT * ALLBUT foo FROM t ...
Could be as well
SELECT * BUTNOT foo, bar FROM t ...
The risk seems much higher with words like SAFE or WITHOUT, which
perhaps have greater probability of being used in some
Darren,
At 02:19 28/09/2009, you wrote:
´¯¯¯
>So my proposed "" is identical to the old "sublist>", and my addition is the optional EXCEPT plus list of not
>derived columns.
>
>Note that I'm not stuck on the keyword EXCEPT, but it should be a word
>that
>reads similarly.
`---
I would love to
Yan,
>I would like to display the contents of blobs in my table as
>hexadecimal. I have not found any easy way of doing this. I tried :
Give SQLite Expert a try. There are both free and Pro version available at
http://www.sqliteexpert.com/index.html
Free version has no hassle license, no
Alexey,
>I'm using extension for base unicode support
>(http://mobigroup.ru/files/sqlite-ext/unicode/), but in last two
>releases find the problem with indexes by columns with redefined
>NOCASE collation
This code has many problems and the version on your site (the same
version is available
At 18:56 17/09/2009, you wrote:
´¯¯¯
> % 99+% of the time, there won't be two updates "at the same time". In
> other words, copy 1's change will almost always propagate to copy 2
> before copy 2 does another update.
`---
The devil is in the 1% and the "almost" of course.
But what do you and
Doug,
At 19:47 15/09/2009, you wrote:
´¯¯¯
>I'm not sure if you are looking to make a entry unique, or determine
>the order in which the entries occurred. In either case, be aware -
>time can go *backwards* on a system, especially if it is being syncd
>to an outside source such as with NTP.
>
At 10:25 14/09/2009, you wrote:
´¯¯¯
>sorry, i meant "columns" not rows, whet i do insert command, specifying
>existing id and only some of the columns then the rest of the columns are
>deleted
>on the other hand, UPDATE command won't allow me to insert a new row
Then you can still do something
At 01:29 14/09/2009, you wrote:
´¯¯¯
>CREATE TABLE table1( id INTEGER PRIMARY KEY ON CONFLICT REPLACE,
>field1 TEXT
>);
>
>but I think that the table has to already have been created this way.
`---
Yes from what he said, I also believe this is the right and simplest way.
I tried twice to post it but it seems it didn't find its way to the
list. Sorry if ever it gets dupped.
Hi,
>insert or replace deletes all rows that weren't specified in the query
Do you have a short example where "INSERT OR REPLACE INTO ..." can be
shown to actually _delete_ rows?
Which
´¯¯¯
>INSERT INTO 'mytable' (key, 'visitorcount', 'visitdate')
>VALUES (123456789, 1, NOW())
>ON DUPLICATE KEY UPDATE 'visitorcount' = 'visitorcount' + 1
>
>the key statement being: ON DUPLICATE KEY UPDATE
>
>not tested but it seems like that is what you are looking for. Its
>sometimes refered
Umm,
At 05:16 03/09/2009, you wrote:
´¯¯¯
>Thanks for reminding me: A thing's value is generally proportional to
>its cost. And the attitude of its support team figures in there, too.
>-R.
>
> >> Whether _you_ consider them problems or not, they were certainly
> >> problems for me, migrating a
Hi,
´¯¯¯
>2. Following up on windows dllmain info - which was very useful in itself
>- but since we use both windows and linux, I checked the equivalent for
>linux as well and yes, luckily, gcc allows you to define a 'function
>attribute' called 'constructor' and 'destructor' which can be used
At 18:25 30/08/2009, you wrote:
´¯¯¯
>When we load an extension it invokes sqlite3_extension_init(). Lets
>say, in
>addition to creating functions, the loaded extension library also does
>some
>internal data structure allocations, initializations etc here.
>
>Now, when the database is closed
I want to use SQLite in a GIS application where I create a database
>containing terrain data (coordinates, height).
>I would like to query this database with start and end points of a
>line and
>get a vector with all heights point along this line.
>I can, of course create a query for each point
´¯¯¯
>No, I meant exactly UCS-2. Because UCS-2 guarantees that all symbols
>are represented by 2 bytes when UTF-16 does not. And I had an
>understanding that Doug said about this 16-bit guarantee. Also if
>we're talking about encoding where any character can be represented by
>a single variable
´¯¯¯
>(btw it's the standard datetime format in germany, not custom-designed
>:-P)
`---
I see this as a confusion between a storage/computational format and
human interface representation.
US "standard" for date is also completely awkward MM/DD/ as well as
most european (german for you,
Hi Pavel,
´¯¯¯
>So conversion between wchar_t and
>UCS-2 encoding is not always as easy as you can think.
`---
Is there really anyone using UCS-2 now or did you mean UTF-16?
___
sqlite-users mailing list
sqlite-users@sqlite.org
Simon,
At 15:26 02/07/2009, you wrote:
´¯¯¯
>What we need is a new version of Soundex which is written to deal with
>unicode instead of ASCII.
`---
Umm, soundex already fails often with plain english names. It would
need a whole lot of native speakers of all those languages around to
come up
Hello group,
I'm writing a fuzzy search extension. The current code is getting a
little messy and I'm not completely satisfied by the way it works. So
I'm about to rewrite it from scratch on stronger foundations.
The goal is to provide a fuzzy search on _short_ fields like names,
street
At 13:25 26/06/2009, you wrote:
´¯¯¯
>I am trying to find words in a dictionary stored in sqlite, and trying
>a near miss approach.
>For that I tried an algorithm to create patterns corresponding to
>Levenshtein distance of 1 (edit distance of 1).
>That means, one adition, one remotion or one
301 - 400 of 406 matches
Mail list logo