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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] >> >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> > >> >> -- >> 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: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> > -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
