Char(100) fields

From: "Waldomiro" <wmiro(at)ig(dot)com(dot)br>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Char(100) fields
Date: 2004-09-22 18:27:15
Message-ID: 003401c4a0d1$c9ea48c0$1001a8c0@shx.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Hi,

I have some char(100) fields.

I was using postgre 7.2 and now I'm using 7.4.

before 7.2 I never had an error inserting some data in a char(100) field.

now I have an error "value too long for type character(100)"

this error ocurrs when I insert some string which has size 100, if I insert some string which has size 99, the error doesn't came.

Is it a bug?

there is a detail, when I do that insert inside a psql program, the error doesn't came, it came only when I do the insert inside a java program.

I think it is a driver problem.

There is someone who have already this kind of problem?

SHX INFORMÁTICA LTDA.
Waldomiro Caraiani
Desenvolvimento de Produto
+ 55 11 5581 1551
wmiro(at)shx(dot)com(dot)br
www.shx.com.br

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2004-09-22 18:38:43 Re: Prioritizing queries
Previous Message Jim C. Nasby 2004-09-22 18:19:54 Re: using database for queuing operations?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jaroslaw J. Pyszny 2004-09-22 19:11:12 Re: Auto-increment serial (Postgresql JDBC driver w/
Previous Message Yi LIN 2004-09-22 17:29:20 Re: Problem linking Postgresql JDBC driverb and Matlab (Linux)