4 Replies Latest reply on May 8, 2002 2:50 PM by Ron Jawanda

    ORACLE CHAR  type and String length problems.

    Ron Jawanda Novice

      I have an oracle table that (Oracle 7) that has CHAR(16) fields that I can't change. The data comes out with spaces prepending the data.
      For example

      char(16) name
      When I print out the name the Java String looks like this


      But the length is 16.
      Is there any way to resolve this using JBOSS?

      It is possible that the data is being inserted in with blanks in the actual data " myname"
      but the extraction of the data via jboss CMP 1.0 In jboss 2.2.4 seems to drop the spaces but ???
      I am confused.
      Hope someone can help me.