Sean, We are using one server and supporting help desks in Japan, China, Singapore, Czech Republic, Germany, the Netherlands, Belgium, Spain, Brazil, Mexico, Great Britain, Canada and the US. At one time it was required to install languages on their own server. A few versions ago, the server was made Uni-code compliant. The issue is that the desk top client is not. When I display a record that entered in Japanese or Chinese using the desktop client, I can not see the characters. If I update the record I run the risk of corrupting the data.
However the MidTier is Uni-code compliant and I can open that same record and update the data without issue. Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sean O'Sullivan Sent: Tuesday, April 24, 2012 4:59 PM To: [email protected] Subject: Mixing Languages in the Database 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
