RE: findByPrimaryKey problem, Oracle char(10) space padding

2000-11-08 Thread Kurt Hoyt
a [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, November 08, 2000 7:16 PM >To: Orion-Interest >Subject: findByPrimaryKey problem, Oracle char(10) space padding > > >I'm having a problem with Orion's findByPrimaryKey() method >when the column >type is CHAR(10). The prob

findByPrimaryKey problem, Oracle char(10) space padding

2000-11-08 Thread John Pletka
I'm having a problem with Orion's findByPrimaryKey() method when the column type is CHAR(10). The problem is Oracle pads out the column to fill in the extra spaces. For example, if you store "KEY" in a CHAR(10) field, Oracle saves it at "KEY ". This does not affect any queries run directl