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] >
