WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #3517


Ignore:
Timestamp:
01/02/2007 06:51:04 PM (14 years ago)
Author:
foolswisdom
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #3517 – Description

    initial v1  
    77For a new installation, its rather easy:
    88
    9 1) All database and table definitions must be set to UTF-8, some examples:
    10 create database wordpress DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
     91) All database and table definitions must be set to UTF-8, some examples:[[br]]
     10create database wordpress DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;[[br]]
    1111create table wp_users (etc...) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    1212
    13 2) Modify the WP database connection to execute the following:
    14 SET NAMES utf8;
     132) Modify the WP database connection to execute the following:[[br]]
     14SET NAMES utf8;[[br]]
    1515SET COLLATION_CONNECTION=utf8_general_ci;
    1616
     
    2626Example steps:
    2727
    28 1) ALTER TABLE users MODIFY Last_Name BLOB;
    29 2) ALTER DATABASE wordpress charset=utf8;
    30 3) ALTER TABLE users charset=utf8;
     281) ALTER TABLE users MODIFY Last_Name BLOB; [[br]]
     292) ALTER DATABASE wordpress charset=utf8; [[br]]
     303) ALTER TABLE users charset=utf8; [[br]]
    31314) ALTER TABLE users MODIFY Last_Name TEXT CHARACTER SET utf8;
    3232