inserting/modifying non displayable charackters
Posted: 11.09.2007, 19:33
When defining a field in a table as char(1) or wider because it is not really relevant for sqlite since it knows only TEXT.
Then I want to insert values like chr(9) chr(0) and many others because I see a char as a value between -127 upto 127 I have to do this like follows.
INSERT INTO T VALUES(x'09');
SQL Server and MySQL also support the char function like this :
INSERT INTO T VALUES(char(9));
-1-
It would be really nice if this function would be available in sqlite as well.
-2-
When now doing :
select * from T;
after selecting any output format you get into trouble, when non displayable charackters are present the string as a whole should be displayed like x'-----'
-3-
I expect
select '1'+'1' to result in '11' and not in 2 if I want this behaviour to appear I have to do this :
select '1' || '1'
is this ansi specified ?
Then I want to insert values like chr(9) chr(0) and many others because I see a char as a value between -127 upto 127 I have to do this like follows.
INSERT INTO T VALUES(x'09');
SQL Server and MySQL also support the char function like this :
INSERT INTO T VALUES(char(9));
-1-
It would be really nice if this function would be available in sqlite as well.
-2-
When now doing :
select * from T;
after selecting any output format you get into trouble, when non displayable charackters are present the string as a whole should be displayed like x'-----'
-3-
I expect
select '1'+'1' to result in '11' and not in 2 if I want this behaviour to appear I have to do this :
select '1' || '1'
is this ansi specified ?
