Notepad:UTF8 and Notepad:SVN Create: Difference between pages

From Amar Wiki
(Difference between pages)
VisualWikitext
 
Created page with "On server with admin: mkdir /usr/share/svn svnadmin create /usr/share/svn/jon.myproject.com svn mkdir file:///usr/share/svn/jon.myproject.com/trunk svn mkdir file:///usr/..."
 
Line 1: Line 1:
= Create a database with UTF-8 =
On server with admin:
[https://dev.mysql.com/doc/refman/5.5/en/charset-applications.html Configuring the Character Set and Collation for Applications]


  CREATE DATABASE <DB>
  mkdir /usr/share/svn
  DEFAULT CHARACTER SET utf8mb4
  svnadmin create /usr/share/svn/jon.myproject.com
  DEFAULT COLLATE utf8mb4_unicode_ci;
  svn mkdir file:///usr/share/svn/jon.myproject.com/trunk
 
  svn mkdir file:///usr/share/svn/jon.myproject.com/tags
  use <DB>;
  svn mkdir file:///usr/share/svn/jon.myproject.com/branches
 
  svn import ~/jon.myproject.com file:///usr/share/svn/jon.myproject.com/trunk
= Move a table to UTF-8 =
  SELECT DISTINCT CONCAT('ALTER TABLE ',TABLE_NAME,' CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;')
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_SCHEMA='%%' AND COLLATION_NAME='latin1_swedish_ci';
 
= Move individual fields to UTF-8 =
  SELECT DISTINCT CONCAT('ALTER TABLE ',TABLE_NAME,' MODIFY ',COLUMN_NAME,' ',COLUMN_TYPE,
  ' CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;')
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA='%%' AND COLLATION_NAME='latin1_swedish_ci';
 
Then before executing:
{code}SET FOREIGN_KEY_CHECKS=0;{/code}

Revision as of 22:42, 12 September 2015

On server with admin: 

mkdir /usr/share/svn
svnadmin create /usr/share/svn/jon.myproject.com
svn mkdir file:///usr/share/svn/jon.myproject.com/trunk
svn mkdir file:///usr/share/svn/jon.myproject.com/tags
svn mkdir file:///usr/share/svn/jon.myproject.com/branches
svn import ~/jon.myproject.com file:///usr/share/svn/jon.myproject.com/trunk
Retrieved from "https://wiki.amar.com/index.php?title=Notepad:UTF8&oldid=460"