Fred, I checked my old and new databases with select collation_name FROM sys.databases where name ='ARSystem'; both returned SQL_Latin1_General_CP1_CI_AS
Is there a way to check the ARServer character set? The old server (ARS 7.6.04) still gives a readable return from soundex. Thank you, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: Thursday, July 31, 2014 11:03 AM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: using SQL soundex function to find similar names Fred, Wouldn't that cause problems with all set fields actions where I'm getting data from other forms or is it because the function is modifying and returning a value? I'll look around to see what I can find. Thank you, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Thursday, July 31, 2014 10:12 AM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: using SQL soundex function to find similar names Remember . The thick client (Windows User Tool) is not truly Unicode compliant It sounds like you may have some sort of mismatch in the character sets (between SQL, the server, and the client) Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: Thursday, July 31, 2014 8:50 AM To: arslist@ARSLIST.ORG Subject: using SQL soundex function to find similar names ** Hello Listers, ARS 8.1.00 MS SQL 2008 MS OS 2008 R2 While I'm working on my DSO issues and the report publisher I also came across a problem in some workflow. I've been calling the soundex() function for years in my Customer Form to make it easier to look for names that may be spelled incorrectly. You know Smith instead of Smyth and such. Since we've moved to the new system the set fields action is returning non-displayable characters in the thick client and what looks to me like oriental characters in Mid Tier. Is this a Unicode setting or does ARS 8.1 not handle the returned varchar properly? I just run a Set Fields filter using SQL as the data source with a query of SELECT SOUNDEX('$User Last Name$') Then I set my field Lname_Soundex with $1$ Can this be corrected or is there a better way to search and manage similar names? Thank you, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"