-
1. Re: ORACLE CHAR type and String length problems.
rgjawanda May 8, 2002 12:43 PM (in response to rgjawanda)Oh yeah..
This is how my string is defined
<java-type>java.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR2(255)</sql-type>
But my field is char(16) and i guess it is using this mapping because it does fill in the string. -
2. Re: ORACLE CHAR type and String length problems.
rgjawanda May 8, 2002 12:56 PM (in response to rgjawanda)SQL> describe baan.ttisfc954001;
Name Null? Type
------------------------------- -------- ----
T$CPRJ NOT NULL CHAR(6)
T$HPRD NOT NULL NUMBER
T$MITM NOT NULL CHAR(16)
T$MPOL NOT NULL NUMBER
T$MORD NOT NULL NUMBER
T$MREV NOT NULL CHAR(6)
T$PONO NOT NULL NUMBER
T$SEQN NOT NULL NUMBER
T$OCMP NOT NULL NUMBER
T$INDT NOT NULL DATE
T$EXDT NOT NULL DATE
T$SITM NOT NULL CHAR(16)
T$OPOL NOT NULL NUMBER
T$REVI NOT NULL CHAR(6)
T$SORD NOT NULL NUMBER
T$QANA NOT NULL NUMBER
T$ADDN NOT NULL NUMBER
T$REFCNTD NOT NULL NUMBER
T$REFCNTU NOT NULL NUMBER
SQL>
SQL> select T$SITM from baan.ttisfc954001 where T$CPRJ='219657' and T$HPRD=200448 and T$MITM='
2330549';
T$SITM
----------------
KIT
013X08
344X28
386X68
832X41
2083918
CLAMP
INJECTION
2339296
9 rows selected.
SQL>
My sql query returns "INJECTION" with a length of 16 even though it is 9 in length. -
3. Re: ORACLE CHAR type and String length problems.
l.g. May 8, 2002 2:38 PM (in response to rgjawanda)Try:
<java-type>java.lang.String</java-type>
<jdbc-type>CHAR</jdbc-type>
<sql-type>CHAR(16)</sql-type> -
4. Re: ORACLE CHAR type and String length problems.
rgjawanda May 8, 2002 2:50 PM (in response to rgjawanda)Thanks
I think that did it.
Ron