[OpenSER-Users] case sensitivity with avp_db_load

Klaus Darilion klaus.mailinglists at pernau.at
Fri Oct 19 10:09:19 CEST 2007


Juha Heinanen wrote:
> 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.

You are right. I've tested it and mysql indeed compares case 
insensitive. In postgresql you have to use ILIKE for case insensitive 
string comparison.

Any ideas how we can make this consistent for openser?

regards
klaus




More information about the Users mailing list