db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From SheraX <sheraz.jams...@redmath.com>
Subject RE: Inserting Special Characters in Oracle using TORQUE.
Date Mon, 29 Oct 2007 06:13:19 GMT

Alright, I understand now. Thanks alot for the help.. I need to look for the
solution with least impact on the application.

Regards

Sheraz Jamshed



Thomas Fischer-11 wrote:
> 
> SheraX <sheraz.jamshed@redmath.com> schrieb am 26.10.2007 12:30:15:
> 
>>
>> Thanks alot for the reply Thomas.
>>
>> Regarding your solution a) how can I check the length for the character
> set
>> that Tourque Uses?
> 
> You misunderstood me. Not Torque uses a characterset, but the database
> does. Check Your database manual for how to find out the characterset of
> your database (usually this is configurable)
> 
>> For solution b) how can I change the db character set?
> 
> Again, this needs to be changed in the database. Check the db manual.
> 
>> Can we change the charset of db from any torque configuration files ?
> 
> Definitely not.
> 
>>
>> Thanks in advance...
>>
>> Sheraz Jamshed
>>
>>
>>
>>
>> Thomas Fischer-11 wrote:
>> >
>> > There are fixed length character sets (each character uses the same
> amount
>> > of space, like ISO-8859-1 (1 byte) or unicode(2 bytes)) and variable
>> > length
>> > character sets where some characters neen more space than others (e.g.
>> > utf-8 where characters can occupy 1-3 bytes). It seems that java and
> the
>> > db
>> > use different character sets. The database or its driver takes care of
> the
>> > conversion, which can lead to a longer byte sequence in the db.
>> >
>> > The solution would be a) to make the length check in the charset of the
> db
>> > or b) use the same charset in the db as in the web application.
>> >
>> >           Thomas
>> >
>> > SheraX <sheraz.jamshed@redmath.com> schrieb am 26.10.2007 08:21:17:
>> >
>> >>
>> >> Hellow everyone,
>> >>
>> >> 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.
>> >> I need to insert special characters like (ABCDEFG1234ÑãäåæçèéêêהЦБЌ)
> 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
>> > boundry
>> >> value checks.
>> >> 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
>> > torque
>> >> tries to insert the value in database the ORA Exception is encountered
>> >>
>> >> "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
>> >>
>> >>
>> >> Regards
>> >>
>> >> SheraX
>> >>
>> >>
>> >> --
>> >> View this message in context: http://www.nabble.com/Inserting-Special-
>> >> Characters-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
>> >>
>> >
>>
>> --
>> View this message in context: http://www.nabble.com/Inserting-Special-
>> Characters-in-Oracle-using-TORQUE.-tf4695403.html#a13424494
>> 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
>>
> 

-- 
View this message in context: http://www.nabble.com/Inserting-Special-Characters-in-Oracle-using-TORQUE.-tf4695403.html#a13462077
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


Mime
View raw message