Klaus Darilion writes:
Yes it is postgres but AFAIK SQL queries are per
default always case
sensitive.
if i remember correctly, this does not hold for mysql = operator.
Here is the query from avp_db_load when the SIP
request has
sip:KLAUS.darilion@example.com in the From URI:
select value,attribute,type from conference_extension where
username='KLAUS.darilion' AND domain='example.com' AND
attribute='106'
As you see it is "username='string'" and a "=" comparison is
case
sensitive.
in order to make that comparison case sensitive, you need to add
"binary" or something like that to the expression.
-- juha