Re: contacts are showing as case sensitive in HPSM 7.01 (110 Views)
Reply
Occasional Contributor
pawano99
Posts: 2
Registered: ‎07-28-2013
Message 1 of 2 (148 Views)

contacts are showing as case sensitive in HPSM 7.01

hii ..

 

i am using HPSM 7.01 , and all contacts are uploded in HPSM . the issue is the contacts are woring as case sensitive to fetch datas and to register a new ticket . is there any option to remove this case sensitive option . kindly suggest .

Honored Contributor
John Stagaman
Posts: 3,425
Registered: ‎07-13-2007
Message 2 of 2 (110 Views)

Re: contacts are showing as case sensitive in HPSM 7.01

[ Edited ]

There is no file-by-file case sensitivity. At startup, SM detects the collation settings of the backend RDBMS and enables/disables case sensitive mode automatically. 

 

There is some code which always converts contact.name to upper case, but even then if the database is set to case-insensitive it is only a cosmetic issue: you can query it with mixed/lower case. 

 

If you've configured the database to be case-sensitive, you could update the link records to case convert before executing the fill link expression. For a case-sensitive environment, however, I generally recommend forcing case for fields (e.g. full name, assignment groups) so that you can convert case on the form and end users never have to be concerned about case. If you loaded the contact information using mixed case data on a case-insenstive system, I'd convert the data to either upper or lower case (for any fields that you allow a search or fill against).

 

----------------------------------------------------
Kudos - what, where, how, and why
Want Good Answers? Ask Good Questions...
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.