At 23:18 Wednesday, 11.05.2005 +0200, Tutti Fruti wrote:

>Table STRINGS has columns
>SID (int, PK)
>ORIGINALSTRING (BLOB SUB_type 1)

[snip]

>sql.CommandText = "SELECT SID FROM STRINGS WHERE ORIGINALSTRING=@orig";

Hi,

I don't think you can compare blobs in an SQL statement. You would have to
use an UDF for this task. A much faster way would be to save the hash value
of the string in a third column and use this value to search for an
existing string.

HTH,
Markus