Thread: Inserting Fingerprint templates as varchar not as bytea type in PostgreSQL

I am not able to insert fingerprint templates in db. I am using the datatype
as varchar(4000).
But when i tried with bytea type itk ok.
Isn't possible to insert these templates as varchar?
I have tried with varchar but its showing the illegal argument exception "\0
not allowed".
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Inserting-Fingerprint-templates-as-varchar-not-as-bytea-type-in-PostgreSQL-tp3258255p3258255.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

Re: Inserting Fingerprint templates as varchar not as bytea type in PostgreSQL

From
Maciek Sakrejda
Date:
PostgreSQL forbids character code 0 (NULL, the delimiter of C-style
strings) in varchar columns.
---
Maciek Sakrejda | System Architect | Truviso

1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com