[OpenSER-Users] case sensitivity with avp_db_load

[Juha Heinanen]

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 at 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