Email is case sensitive, how can I change this?

Moderator: crythias

Locked
soos
Znuny newbie
Posts: 38
Joined: 12 Mar 2014, 11:53
Znuny Version: 3.3.1
Real Name: O

Email is case sensitive, how can I change this?

Post by soos »

Hi,

If a customer sends an email from Firstname.Lastname@Company.com it's not matched to firstname.lastname@company.com as it's described in our Active Directory, so our agents have to manually select the correct customer after the ticket has come in, is there a way to make email addresses always be lower case?
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Email is case sensitive, how can I change this?

Post by jojo »

use a non case sensitive database
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
soos
Znuny newbie
Posts: 38
Joined: 12 Mar 2014, 11:53
Znuny Version: 3.3.1
Real Name: O

Re: Email is case sensitive, how can I change this?

Post by soos »

OK, I don't think changing the data source or anything is going to be possible...
soos
Znuny newbie
Posts: 38
Joined: 12 Mar 2014, 11:53
Znuny Version: 3.3.1
Real Name: O

Re: Email is case sensitive, how can I change this?

Post by soos »

Is there a way to have OTRS make the queries with LOWER() or something? Is there a config setting for this? I am using postgresql 9.3.
Locked