Going crazy comparing bytea columns

From: scomp(at)canada(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Going crazy comparing bytea columns
Date: 2006-03-01 18:40:39
Message-ID: 4405eaa7.238.999.19861@canada.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I am new to Postgresql, so pls be patient.

I am using npgsql with C# to insert a bytea value into a
column which will serve as an encrypted password. This works
well. However, when I retrieve the value, it is different.
In other words, "select pwd from table where pwd like @pwd"
does not work.

Is it not possible to compare bytea columns?

...get dbConn...

NpgsqlCommand cmd = new NpgsqlCommand("select pwd from table
where usr = @usr and pwd like @pwd",dbConn);
cmd.Parameters.Add(new NpgsqlParameter("usr",DbType.String);
cmd.Parameters.Add(new
NpgsqlParameter("pwd",NpgsqlTypes.NpgsqlDbType.Bytea);
cmd.prepare()
... set param values, call executereader...

Thanks,

JM

----------------------------------------
Upgrade your account today for increased storage; mail
forwarding or POP enabled e-mail with automatic virus
scanning. Visit our member benefits page at
https://members.canada.com/benefits.aspx for more
information.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message koder 2006-03-01 18:56:26 Installing PosygreSQL 8.1 on Windows2003 server in terminal session (remote desktop)
Previous Message falcon 2006-03-01 18:39:24 a web framework for postgresql?