Username with spaces (MySQL)

Wilco Baan Hofman wilco at
Thu Apr 18 09:47:11 CEST 2013

On Wed, 2013-04-17 at 22:03 -0500, Andres Gomez Ruiz wrote:

> So I have many users using the same username putting one, two,
> three, ...etc., spaces after the username.
> How can I solve this situation?
> May be with a SQL query that ignores the spaces in the username?
> (talking about the sql counters)
Not really a RADIUS question, but this is default behaviour for MySQL.
Convert the VARCHAR Field to binary or use TRIM() for the counters.


Wilco Baan Hofman

More information about the Freeradius-Users mailing list