SMF Database -> Common collation, character set & engine type settings tool version 1.1 This tool uses your default database settings for common configurations. It will adjust all tables & columns to match.

This Simple Machines Forum Database Tool c/o Underdog @ http://askusaquestion.net

Copyright 2012, 2013 Underdog @ askusaquestion.net

SMF DB Common Collation & Engine is distributed under the terms of the GNU General Public License (http://www.gnu.org/licenses/gpl.txt)

Please remember to backup your database prior to using this tool. With this version (v1.1) it is advised to use this tool only when working with a single common character set (ie. utf8).

Simply uninstall this modification when it has completed its adjustments.

Disclaimer:

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Version 1.1

• Collation & character set now based on overall database setting
• Previous query did not work for database designations containing hyphens

Version 1.0

• Initial release
• Sets collation & character set for all tables to be uniform