From: Mark D Powell Subject: Re: a problem in about CHAR column in the select statement Date: 2000/07/07 Message-ID: <05d85908.799bcb7e@usw-ex0103-024.remarq.com>#1/1 References: <8k5964$1lm$1@nnrp1.deja.com> Bytes: 1042 X-Originating-Host: 199.228.142.8 X-Complaints-To: wrenabuse@remarq.com X-Trace: WReNphoon4 963001478 10.0.2.24 (Fri, 07 Jul 2000 13:24:38 PDT) Organization: http://www.remarq.com: The World's Usenet/Discussions Start Here NNTP-Posting-Date: Fri, 07 Jul 2000 13:24:38 PDT Newsgroups: comp.databases.oracle.server X-Wren-Trace: eMbjy8rTlN6Vi9PcyMjXwMPQ2s/jx4LDjcnGyI+Dht+HktSfhteHmoSf I do not know anything about JAVA to Oracle but it sounds like your table is defined with a char column. You might want to try redefining it to be varchar2. You may also want to check the JAVA documentation for JAVA datatype to Oracle conversion rules to see if changing the datatype will affect the comparison. In worst case you should be able to use the rtrim(col) to remove trailing blacks from the database column data; however using a function on the column will disable retriving the data via an index which is probably not good. If the table column is varchar2 check to see if trailing blanks, nulls, or newlines were stored in the column. It is possible to do that and you can use the ltrim function in an update statement to clean the data and then retest. I hope this helps until someone more knowlegable about JAVA sees your post. ----------------------------------------------------------- Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free! http://www.keen.com