Adam Hammond wrote:
I'm having a problem with the safe chars check in rlm_sql (postgresql driver) mime encoding characters that are not in it's safe_characters list (i.e. it's doing what it's supposed to). I've run into this recently with users from the European continent using accented characters (or umlauts, cyrillic text etc). The usernames are stored on my server in UTF8 encoding, but the SQL the module runs is obviously not matching the username if it contains a character not in the safe_characters list.
I note several old threads on this subject, one of which suggests that the safe chars check is not UTF8 capable (at version 2.1.x). My production server is running 2.1.10 so, accordingly, I have installed v3.0.5 to test.
The simplest solution would be to treat the input as UTF-8. For backwards compatibility, this would have to be configurable. Alan DeKok.