db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject RE: Inserting Special Characters in Oracle using TORQUE.
Date Fri, 26 Oct 2007 11:42:09 GMT
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
>
Mime
View raw message