> I created a character field with 20 characters length. For character fields, "Input Length" determines the maximum number of bytes the field can contain. Since input length is in bytes, you probably created a character field of 20 bytes in length, not characters. This is documented in the "Form and Application Objects" manual.
> 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... Correct. AR System developers tend to triple the number of single-byte characters needed in fields to enable multi-byte or unicode data. In other words, if you expect 20 "characters" in English, you should allocate 60 bytes to the field if the field may contain multi-byte languages. > Is really ARS Unicode supported??? In 6.3, Unicode databases are supported, but the server is not Unicode compliant. Basically (and way over-simplified), if you wanted to support German and Japanese within your company, you would need two AR system servers - one that could support Japanese and one that could support German - connected to your Unicode database. In 7.0, the server and web client were modernized to be Unicode compliant. The server in 7.0 can now be used to process multiple languages in Unicode. Thus to support German and Japanese, only one AR System would be required. The Windows User Tool and Admin Tool are still not Unicode compliant. There are two white papers available about Unicode in AR System 7.0 and 7.0.01 on Support Central. The Link to the AR System page is: http://www.bmc.com/support/hou_Support_ProdVersion/0,3648,19097_19695_144856_0,00.html Systems using Unicode data could not be upgraded to AR System 7.0.00. AR System 7.0.01 added this ability so Unicode customers wishing to upgrade from a previous version of AR System should upgrade to AR System 7.0.01. Further information about Unicode support is found within the AR System release notes for AR System 7.0.00 and 7.0.01. Hope this helps, -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jose Manuel Viejo Lobato Sent: Monday, November 13, 2006 11:58 PM To: [email protected] Subject: Is really Unicode Supported in ARS 6.3? 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 can't 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 don't 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 don't 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
