Re: Char(100) fields

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Waldomiro" <wmiro(at)ig(dot)com(dot)br>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Char(100) fields
Date: 2004-09-22 19:50:43
Message-ID: 18347.1095882643@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

"Waldomiro" <wmiro(at)ig(dot)com(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Miles Keaton 2004-09-22 21:12:43 download documentation as HTML (not PDF)
Previous Message Jim C. Nasby 2004-09-22 18:38:43 Re: Prioritizing queries

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-09-22 19:50:46 Re: Problem linking Postgresql JDBC driverb and Matlab (Linux)
Previous Message Jaroslaw J. Pyszny 2004-09-22 19:11:12 Re: Auto-increment serial (Postgresql JDBC driver w/