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:[EMAIL PROTECTED] 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

_______________________________________________
Users mailing list
Users@openser.org
http://openser.org/cgi-bin/mailman/listinfo/users

Reply via email to