summaryrefslogtreecommitdiff
path: root/docs/MySQL.md
blob: c463c1f00ab327f8f81bed6f24c299d776f2cac0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
# How to install rfc1459 character set into MySQL:

Copy data/mysql/rfc1459.xml to your character_sets_dir, identified by

```
SHOW VARIABLES LIKE 'character_sets_dir';
```

Add the following charset to Index.xml in the character_sets_dir directory:

```
<charset name="rfc1459">
  <collation name="rfc1459_ci" id="800"/>
  <collation name="rfc1459_inspircd_ci" id="801" flag="primary"/>
</charset>
```

Restart MySQL.

Now create the database using the appropriate character set:

```
CREATE DATABASE anope DEFAULT CHARACTER SET rfc1459 DEFAULT COLLATE rfc1459_inspircd_ci;
```