correct table collation for all tables

I’m having problems installing the Super Search plugin. It’s giving an error about installing the Levenshtein function. The developer doesn’t seem willing to go beyond simple troubleshooting to resolve it. (confirming the db user has alter and drop privs, which it does)

Looking at my database I see that 7 tables are using latin1_swedish_ci collation. Is this correct? The rest are set for utf8_general_ci.

The 7 tables are: exp_accessories exp_channel_entries_autosave exp_cp_search_index exp_fieldtypes exp_layout_publish exp_snippets exp_upload_no_access

I’m running EE 2.10.3 on IIS8. (Win 2012r2)

A Database Error Occurred
Error Number: 1370

alter routine command denied to user 'abc_ee_user'@'localhost' for routine 'abc_ee_01.LEVENSHTEIN'

DROP FUNCTION IF EXISTS LEVENSHTEIN;

Filename: D:\web\abc\system\codeigniter\system\database\DB_driver.php

Line Number: 382

As an aside, I temporarily gave the db user ALL privileges and tried the plugin install and it worked. Any idea why the db user would need more than the EE default to install itself?

[select, insert, update, delete, create, alter, index, drop]

I’m not sure which added privilege it required but I’d guess either ‘create routine’ or ‘alter routine’.