The following bug has been logged online: Bug reference: 3732 Logged by: George Woodman Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Windows 2000 Description: Select returns 0 rows for varchar field Details:
I created a table with the following specs. CREATE TABLE user_control ( uci character varying(10) NOT NULL, ucname character varying(20), ucpwd character varying(10), ucrole character varying(20), CONSTRAINT user_control_pkey PRIMARY KEY (uci) ) WITH (OIDS=FALSE); ALTER TABLE user_control OWNER TO postgres; GRANT ALL ON TABLE user_control TO postgres; I have 2 records with the following details: george,George,george,developer 1234567890,Temp,0,developer When I try to retrieve this record with the following statement from a ASP.Net (VB) app I get no rows returned. Select * from user_control where uci = 'george' However this statement works. Select * from user_control where uci = '1234567890' ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq