Skip to content

Instantly share code, notes, and snippets.

@decebal

decebal/change_collation.sql

Created October 1, 2012 12:14
Show Gist options
  • Save decebal/3811277 to your computer and use it in GitHub Desktop.
Save decebal/3811277 to your computer and use it in GitHub Desktop.
Download ZIP
Change table collation
Raw
change_collation.sql
alter table csshop_products_prospect convert to character set utf8 collate utf8_general_ci
Raw
settings.php
//add to db-settings
$db->query("SET NAMES utf8");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment