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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
