[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 sr-users
mailing list