Postgres Pro
Downloads
Home   >   mailing lists

Re: Char(100) fields - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Char(100) fields
Date
Msg-id 18347.1095882643@sss.pgh.pa.us
Whole thread Raw
In response to Char(100) fields  ("Waldomiro" <wmiro@ig.com.br>)
List pgsql-jdbc
Tree view 
"Waldomiro" <wmiro@ig.com.br> writes:
> now I have an error "value too long for type character(100)"

Perhaps you are using unicode but forgot to set up the database with the
proper encoding?  The DB is going to count bytes not characters if it's
in SQL_ASCII encoding, for example.

            regards, tom lane

pgsql-jdbc by date:

Previous
From: "Jaroslaw J. Pyszny"
Date:
Subject: Re: Auto-increment serial (Postgresql JDBC driver w/
Next
From: Kris Jurka
Date:
Subject: Re: Problem linking Postgresql JDBC driverb and Matlab (Linux)