Hi,
I've encountered a problem with SQLite version 3.18.0 about how
it handles multibyte characters.
Consider this table:
CREATE TABLE film
(
id INTEGER PRIMARY KEY ,
titre VARCHAR ( 50 ) NOT NULL ,
sortie DATE NOT NULL
) ;
filled with these data:
INSERT INTO film VALUES ( 1 , 'La Traversée de Paris' , '1956-10-26' ) ;
INSERT INTO film VALUES ( 2 , 'Les Tontons flingueurs' , '1963-11-27' ) ;
INSERT INTO film VALUES ( 3 , 'Touchez pas au grisbi' , '1954-03-17' ) ;
INSERT INTO film VALUES ( 4 , 'Les Misérables' , '1958-03-12' ) ;
When I run the command-line sqlite client that way :
sqlite3 -column -header exemple.db
The following query has it last column badly aligned when the
second column contains an accented (2 bytes) character, which is
counted for two bytes but dispplayed as 1 character:
sqlite> select * from film ;
id titre sortie
---------- ---------------------- ----------
1 La Traversée de Paris 1956-10-26
2 Les Tontons flingueurs 1963-11-27
3 Touchez pas au grisbi 1954-03-17
4 Les Misérables 1958-03-12
Is there a parameter to fix this or is it a bug?
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
