Postgres Pro
Downloads
Home   >   mailing lists

Re: Using java.lang.Character for "char" data type - Mailing list pgsql-jdbc

From Craig Ringer
Subject Re: Using java.lang.Character for "char" data type
Date
Msg-id 4BF7A718.50607@postnewspapers.com.au
Whole thread Raw
In response to Re: Using java.lang.Character for "char" data type  (Kris Jurka <books@ejurka.com>)
Responses Re: Using java.lang.Character for "char" data type  (Kris Jurka <books@ejurka.com>)
Re: Using java.lang.Character for "char" data type  (Lew <noone@lewscanon.com>)
List pgsql-jdbc
Tree view 
On 22/05/2010 6:16 AM, Kris Jurka wrote:

> It would be possible to support setObject for a Character, but be aware
> that "char" is not a character long, it's a byte long, so it will fail
> on multibyte characters.

So really the appropriate SQL type for Java 'Character' is varchar(1) ?
And a PostgreSQL 'char' (bpchar, not character(1)) maps best to a Java
'Byte' ?

--
Craig Ringer

pgsql-jdbc by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: After server restart I get - An I/O error occured while sending to the backend.
Next
From: Craig Ringer
Date:
Subject: Re: After server restart I get - An I/O error occured while sending to the backend.