Characters like those are stored as double bytes, so the actual length would be more than the visible length. The only way is bump up the field a bit more if required.. Generally the right hand rule is a 25% increase in length of fields when using Unicode..
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Andrew Fremont Sent: Monday, March 24, 2008 1:00 PM To: [email protected] Subject: Error ARERR [306] on having 128 characters on the field with 128 field length on the UNICODE server ** Hi all, We have a field (Short Description) to stored the first of 128 characters of the ticket details, but whenever the first 128 characters in the Short Description has the these character –éáê- then the system returns the error: ARERR [306] Value does not fall within the limits specified for the field : (Maximum length - 128) : There is no issue as long as the string does not have any special characters –éáê- We're using the substrC and lengthC function to truncate the string to the length of the field. AR Server (UNICODE) 7.0.1 pach 005 SQL 2003 Is there a way to truncate the field to match with the field length for the multi-byte languages? AF No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.8/1340 - Release Date: 3/23/2008 6:50 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
