> BMC (Remedy) has always stated that its a bad idea to mix languages in your > database.
That was true prior to 7.0.00 - but hasn't been true now for almost 7 years now. Using Unicode as your character set enables you to have multiple languages (but not multiple character encodings) in your database. Were you to be able to start over, the recommendation would be to use Unicode. Also note that the Remedy user client is not Unicode safe, so if using Unicode - use the web client. -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sean O'Sullivan Sent: Tuesday, April 24, 2012 1: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"
