Oh man, you saved me hours!!, I was having too the "error reading from database" when creating a new user on moodle 3.7.2 , i made the change you suggested and everything is working now.
But, which could be the implications of changing the dbcollation on a production site?