1--
2-- VARCHAR
3--
4
5CREATE TABLE VARCHAR_TBL(f1 varchar(1));
6
7INSERT INTO VARCHAR_TBL (f1) VALUES ('a');
8
9INSERT INTO VARCHAR_TBL (f1) VALUES ('A');
10
11-- any of the following three input formats are acceptable
12INSERT INTO VARCHAR_TBL (f1) VALUES ('1');
13
14INSERT INTO VARCHAR_TBL (f1) VALUES (2);
15
16INSERT INTO VARCHAR_TBL (f1) VALUES ('3');
17
18-- zero-length char
19INSERT INTO VARCHAR_TBL (f1) VALUES ('');
20
21-- try varchar's of greater than 1 length
22INSERT INTO VARCHAR_TBL (f1) VALUES ('cd');
23INSERT INTO VARCHAR_TBL (f1) VALUES ('c     ');
24
25
26SELECT * FROM VARCHAR_TBL;
27
28SELECT c.*
29   FROM VARCHAR_TBL c
30   WHERE c.f1 <> 'a';
31
32SELECT c.*
33   FROM VARCHAR_TBL c
34   WHERE c.f1 = 'a';
35
36SELECT c.*
37   FROM VARCHAR_TBL c
38   WHERE c.f1 < 'a';
39
40SELECT c.*
41   FROM VARCHAR_TBL c
42   WHERE c.f1 <= 'a';
43
44SELECT c.*
45   FROM VARCHAR_TBL c
46   WHERE c.f1 > 'a';
47
48SELECT c.*
49   FROM VARCHAR_TBL c
50   WHERE c.f1 >= 'a';
51
52DROP TABLE VARCHAR_TBL;
53
54--
55-- Now test longer arrays of char
56--
57
58CREATE TABLE VARCHAR_TBL(f1 varchar(4));
59
60INSERT INTO VARCHAR_TBL (f1) VALUES ('a');
61INSERT INTO VARCHAR_TBL (f1) VALUES ('ab');
62INSERT INTO VARCHAR_TBL (f1) VALUES ('abcd');
63INSERT INTO VARCHAR_TBL (f1) VALUES ('abcde');
64INSERT INTO VARCHAR_TBL (f1) VALUES ('abcd    ');
65
66SELECT * FROM VARCHAR_TBL;
67