Hello,
In mysql:
mysql> SELECT * FROM test1 WHERE a=501;
+------+
| a |
+------+
| 501 |
+------+
1 row in set (0.02 sec)
mysql> SELECT * FROM test1 WHERE a=502;
+-------+
| a |
+-------+
| 502 |
+-------+
1 row in set (0.00 sec)
mysql> SELECT * FROM test1 WHERE a<'502';
+-------+
| a |
+-------+
| 501 |
| 502 |
+-------+
2 rows in set (0.00 sec)
and for the second table:
mysql> SELECT * FROM test2 WHERE b='503';
+------+
| b |
+------+
| 503 |
+------+
1 row in set (0.09 sec)
mysql> SELECT * FROM test2 WHERE b>'503';
+------+
| b |
+------+
| 504 |
+------+
1 row in set (0.00 sec)
Regards,
----- Original Message -----
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 13, 2004 1:42 AM
Subject: Re: [sqlite] Re: SQLite version 3 design question: '500'=500?
Who can tell me what other SQL database engines do with
the following?
CREATE TABLE test1(a VARCHAR(100));
INSERT INTO test1 VALUES('501');
INSERT INTO test1 VALUES(' 502 ');
SELECT * FROM test1 WHERE a=501;
SELECT * FROM test1 WHERE a=502;
SELECT * FROM test1 WHERE a<'502';
Or how about this:
CREATE TABLE test2(b INTEGER);
INSERT INTO test2 VALUES(503);
INSERT INTO test2 VALUES(504);
SELECT * FROM test2 WHERE b='503';
SELECT * FROM test2 WHERE b>'503';
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
