Hi All; I am using ARS 6.3 with DB2 8.1, and I have SERIOUS problems with Unicode and multi-byte special characters.
I created a character field with 20 characters length. When I write a value in this field, if I use "single-byte" characters (a-b- c), I can write a maximum of 20 characters. OK. But if I use special characters or "multi-byte" characters (ñ-ó-ò...), I cant write 20 characters because I get a length error (ARERR 552). This is because multi-byte characters are more than a character, so if I write 20 characters and one of this is a multi-byte character, the length of the value is more than the max allowed in the database. This is the way ARS 6.3 works with Unicode, but in another installation as Non-Unicode, I have no problems. To resolve this, I need to calculate MANUALLY what could be the length of the value with this special characters, and make the field bigger (all the fields in all the tables ) or install everything again without Unicode. I dont know if this is only related to DB2 or is the same in other databases (ORACLE, SQL, Informix ) I have a few questions: Do I need to know the way database handle the data, and how many bytes are needed to save the data? And if I know it, What? I wont modify the field length in the database manually. One of the advantages of ARS is that there is no needed databases knowledge (if you dont use Unicode, of course) What are the advantages of UNICODE? (if you use this multi-byte characters, you could have more problems than advantages). Is really ARS Unicode supported??? Regards; Jose Manuel Viejo Lobato [EMAIL PROTECTED] ViejoLobato S.L. www.viejolobato.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
