Re: Porting from Mysql to Postgres

On Thu, 1 Feb 2001, Dror Matalon wrote:

> 1. When I insert a CHAR field and then fetch it, I find out that the
> server padded it with spaces to the size of the field.

This is correct behavior, according to the SQL standard.

> This happens in Postgres but not in MySQL.

Actually, it happens in MySQL, too, sometimes, but it's not always easy
to predict intuitively when it will happen.

> I'm using String.trim() on it on the Java side. Is there a better
> way to do this, like setting a flag to tell the server to trim?

You could use VARCHAR instead of CHAR, but the approach you're using is
probably fine, because most (all?) Java runtimes perform that operation
very efficiently, without any unnecessary allocation/copying.

--
Bob Kline
mailto:bkline(at)rksystems(dot)com
http://www.rksystems.com