George Woodman wrote:
> 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'
George Woodman wrote:
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);
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