ERROR: value too long for type character varying(8)
********** Error **********
ERROR: value too long for type character varying(8)
SQL state: 22001
I used following script to add a Row:
INSERT INTO tbluser(
userid, username, password, name, birthdate, sscper, fees,
lastaccessedtime)
VALUES (1, 'elitecore','elite', 'Elitecore', '2003-1-1',88.1,700.50,
DEFAULT);
I created my table with this create script:
CREATE TABLE tbluser
(
userid integer,
username character varying(8),
"password" character varying(8),
"name" character varying(60),
birthdate date,
sscper numeric,
fees numeric,
lastaccessedtime timestamp without time zone
)
WITH (
OIDS=FALSE
);
Kidly help as early as possible: