From torque-dev-return-8118-apmail-db-torque-dev-archive=db.apache.org@db.apache.org Fri Oct 26 06:21:48 2007 Return-Path: Delivered-To: apmail-db-torque-dev-archive@www.apache.org Received: (qmail 22570 invoked from network); 26 Oct 2007 06:21:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 26 Oct 2007 06:21:48 -0000 Received: (qmail 18038 invoked by uid 500); 26 Oct 2007 06:21:35 -0000 Delivered-To: apmail-db-torque-dev-archive@db.apache.org Received: (qmail 18024 invoked by uid 500); 26 Oct 2007 06:21:35 -0000 Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Developers List" Reply-To: "Apache Torque Developers List" Delivered-To: mailing list torque-dev@db.apache.org Received: (qmail 18012 invoked by uid 99); 26 Oct 2007 06:21:35 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Oct 2007 23:21:35 -0700 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Oct 2007 06:21:38 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1IlIZJ-0007qi-Ku for torque-dev@db.apache.org; Thu, 25 Oct 2007 23:21:17 -0700 Message-ID: <13421479.post@talk.nabble.com> Date: Thu, 25 Oct 2007 23:21:17 -0700 (PDT) From: SheraX To: torque-dev@db.apache.org Subject: Inserting Special Characters in Oracle using TORQUE. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Nabble-From: sheraz.jamshed@redmath.com X-Virus-Checked: Checked by ClamAV on apache.org Hellow everyone,=20 I am getting a strange problem. I am developing a webapplication in IBM Rational Software Development Platform Version: 6.0.1 Using Torque Version 3.0.2.=20 I need to insert special characters like (ABCDEFG1234=C3=91=C3=A3=C3=A4=C3= =A5=C3=A6=C3=A7=C3=A8=C3=A9=C3=AA=C3=AA=D7=94=D0=A6=D0=91=D0=8C) into an Oracle(10g) Table Column of type VARCHAR2(4000 BYTE). The Charset of web application is default IS0-8859. The value is saved in database and retrieved and displayed fine. But the problem arises on boundr= y value checks.=20 Now the string containing special characters of higher decimal ASCII value occupy more bytes then lower ASCII value. So the length of the string is different then the number of characters input by user. Before inserting into database I validate the input value in the form to be less then 4000 bytes (using myValue.length() ). It indeed shows value less then 4000 like in one case the length of the string is 3680. But when torqu= e tries to insert the value in database the ORA Exception is encountered=20 "org.apache.torque.TorqueException: Data size bigger than max size for this type: 4245" I am not able to understand why string length changes when torque tries to insert it into the database. Awaiting Response=20 Regards SheraX --=20 View this message in context: http://www.nabble.com/Inserting-Special-Chara= cters-in-Oracle-using-TORQUE.-tf4695403.html#a13421479 Sent from the Apache DB - Torque Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org For additional commands, e-mail: torque-dev-help@db.apache.org