Package: sqlite3
Version: 3.5.9-3
Severity: important
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Here is a unicode SQL script:
- -----------------
CREATE TABLE foo (a varchar(10) UNIQUE);
INSERT INTO foo (a) VALUES ('@');
INSERT INTO foo (a) VALUES (NULL);
INSERT INTO foo (a) VALUES ('●');
INSERT INTO foo (a) VALUES ('☮');
SELECT DISTINCT a FROM foo WHERE a IS NOT NULL;
- -----------------
sqlite (version 2), mysql, and postgresql all produce (what i think
is) the correct output:
- -------------
@
●
☮
- -------------
But instead sqlite3 returns:
- -------------
●
☮
- -------------
This is a serious problem, because it seems that i cannot rely on
sqlite3 to do proper distinct matching on a utf-8 string.
If i can help with further debugging, i'd be happy to do so.
--dkg
- -- System Information:
Debian Release: lenny/sid
APT prefers testing
APT policy: (500, 'testing'), (200, 'unstable'), (101, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.6.26-1-686 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages sqlite3 depends on:
ii libc6 2.7-13 GNU C Library: Shared libraries
ii libreadline5 5.2-3 GNU readline and history libraries
ii libsqlite3-0 3.5.9-3 SQLite 3 shared library
sqlite3 recommends no packages.
Versions of packages sqlite3 suggests:
ii sqlite3-doc 3.5.9-3 SQLite 3 documentation
- -- no debconf information
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iQIVAwUBSOpaBszS7ZTSFznpAQKfxg/7ByKAocThG9jL0fIttXQyJsVgt2xmQqsY
vqwCCiK36x7+Z0GbD6bbS1K0m30iGA18JoBrm8naLQN/x08voWRfBGfwcd6VABSZ
bfRGx1IpKaDa9Pbjf1z8MuwvARboWiVkqbraJfURkx9m/IIZuWtf+C730p6jkmX8
9karcM5Sdok34p0Spp4C5fNkiRviIDNn/3CrXQKVGRWAwqXsl0nhvKuH5AcSnOlc
GZ7XvEiCYUfxMuOAZhlOBoLiKkG537IEuEJhbwh6MlF7FlYYNqTelKR39Qxh7ec8
PRV/kSDfKm/t57A7e46MsUVovN80BHlUJL0oY05yotuPRTJhEqFHQVNoGmzDk0tR
rIa2ZrP2PidkQQFPAgbKB8vwB9D7g/JeTc/EVbEvPEaZn7xA3cNnFMR4BUG6C+xD
UgNBA7e252ouFxEnnpEtckNvUey+5ADa0P8G2uYI/PDLD+SvBtxXFZtnffEx/wuS
vz1IRkKhRgih6z0il/hkvL8nFLxqTLP4qr9NpRZWU9H1YQR/726TWZSKWOfSjTYb
NBppk154TW3wRlXzAhzgck68qekW6Us+ncsYXIBlCPpxWcE/uo38UxSN3pTkM1DB
/iAEOk0vIq7hsyYqEd4X8YOZmxVQRct4txIahZ2GNrBvA9kfYyDE8bHiwFzRklF5
IEoTBR30+uQ=
=tNM/
-----END PGP SIGNATURE-----
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
