added LC_COLLATE to the aggregate functions.