19 Oct
2007
19 Oct
'07
4:58 a.m.
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