Unable to insert data !

Hello Everyone !

I am using postgresql as a backend. At the time inserting data it generates following errors.

Query execution failed !!! ERROR: value too long for type character varying(4).

Pl. note that I have checked the data type and length of fields in table and same at my Java program. Can anyone suggest the soultion to overcome this problem.

With Thanks !

prashant

[410 byte] By [prashant@banasdairy.coopa] at [2007-11-27 5:34:36]
# 1
note that java uses unicode to represent its character data means it stores each one character into 2 bytes.then if you insert 10 characters into a database field, that field m=have to be at least of length 20.Good LuckAhmad Elsafty
NourElsaftya at 2007-7-12 15:02:49 > top of Java-index,Java Essentials,New To Java...