[sqlite] Floating point numbers

2012-07-15 Thread Klaas Van Be 

Steven E. Harris  wrote:


Another one I can't figure out:

Value     Exponent E     Significand M (in hex)
=   =   ==
100.1     2                    03 02

I expect that this should have the digits 01, 00, and 10, yielding:

  2 * 01 + 1 = 3   = 0x03
  2 * 00 + 1 = 1   = 0x01
  2 * 10     = 20  = 0x14


More about this: 
http://en.wikipedia.org/wiki/IEEE_floating_point


Footnotes: 
¹ http://www.sqlite.org/src4/doc/trunk/www/key_encoding.wiki 


Cordiali saluti/Vriendelijke groeten/Kind regards,
Klaas V
http://innocentisart.net
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Odd insertion error FTS4 + ICU (E. Timothy Uy)

2012-06-20 Thread Klaas Van Be 
>> >> inserting the following into my virtual table:
>> >>
>> >> 一日耶羅波安出
>>
>> Can you post the list of codepoints in this text? Or the hex
>> of the utf-16 or utf-8 encoding of the same?

00 4E E5 65 36 80 85 7F E2 6C 89 5B FA 51


Here no problem inserting this string (Mac OSX 10.6.8)

sqlite> create table u8_t (u8c1 varchar(32));
sqlite> insert into u8_t values ('一日耶羅波安出');
sqlite> .mode list
sqlite> select * from u8_t;
u8c1
一日耶羅波安出
sqlite> .quit
[[bash SQLite]]
sqlite Club.sl3
SQLite version 3.7.13 2012-06-11 02:05:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> 

 

Cordiali saluti/Vriendelijke groeten/Kind regards,
Klaas V
http://innocentisart.net
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] .nullvalue

2012-06-11 Thread Klaas Van Be 
Ciao fellow SQLite users,

We're supposed to be able to change the representation of the NULL value.
Whatever parameter I choose it does not seem to work. I always get an empty 
string.

What I did wrong in this sample table, the commands or parameters?

sqlite> .nullvalue *
sqlite> select numinsng "#", ttlofsng "s", prfofsng "a" from numsong where 
numinsng <1;
#|s|a
0|| 
sqlite> .nullvalue "*"
sqlite> select numinsng "#", ttlofsng "s", prfofsng "a" from numsong where 
numinsng <1;
#|s|a
0|| 
sqlite> .nullvalue "void"
sqlite> select numinsng "#", ttlofsng "s", prfofsng "a" from numsong where 
numinsng <1;
#|s|a
0|| 
sqlite> .mode line 
sqlite> select numinsng "#", ttlofsng "s", prfofsng "a" from numsong where 
numinsng <1;
    # = 0
    s = 
    a =  
sqlite> .nullvalue "?"
sqlite> select numinsng "#", ttlofsng "s", prfofsng "a" from numsong where 
numinsng <1;
    # = 0
    s = 
    a =  
sqlite> .nullvalue ?
sqlite> select numinsng "#", ttlofsng "s", prfofsng "a" from numsong where 
numinsng <1;
    # = 0
    s = 
    a =  
sqlite> .nullvalue 'void'
sqlite> select numinsng "#", ttlofsng "s", prfofsng "a" from numsong where 
numinsng <1;
    # = 0
    s = 
    a =  

FYI the entire table

sqlite> .mode list  
sqlite> select * from numsong order by 1;
numinsng|ttlofsng|prfofsng
0|| 
1|one|U2
7|seven seconds|Nene Cherry
40|'40'|U2
2000|2000 miles|Pretenders



Thanks in advance for your cooperation and/or help. 


Cheers,
Klaas V
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users