Good Afternoon Listers, BMC (Remedy) has always stated that its a bad idea to mix languages in your database. They state that you risk currupting the database.
Because of this we put up a Japanese Remedy server for Japan when we started supporting businesses there and its working fine. However, we have a problem in that sometimes users enter other languages into our worklogs of our English language Remedy system. (Polish, Japanese) The text doesn't show up properly in the Remedy client. It looks like garbage. We told users not to enter non-english text, but sometimes they do anyway. This has not caused us a problem so far, but I am concerned about it eventually currupting our database as BMC warned. My two questions are: 1. Has anyone had any database curruption issues caused by someone entering non-English characters in an English language Remedy? 2. Does anyone know of a way to put in code to prevent other languages from being entered? I thought about something at the database level....maybe a trigger... Thanks for any input you may have. Sean O'Sullivan Prudential Financial _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"