/
Database setup

Citesphere Documentation

Database setup

Owned by Julia Damerow
Mar 23, 2020
1 min read

Create the database with the write character set.

CREATE DATABASE citesphere CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

After tables have been created (app has started up), the following needs to be changed:

alter table jv_snapshot modify state longtext;

 

Related content

Developer Documentation
Developer Documentation
Citesphere Documentation
Read with this
Converting MySQL to UTF8mb4 encoding to handle special characters (Example: Č, ā)
Converting MySQL to UTF8mb4 encoding to handle special characters (Example: Č, ā)
Citesphere Documentation
More like this
MySQL
MySQL
DigInG Knowledge Base
More like this
UnmappableCharacterException error in pom.xml plugin
UnmappableCharacterException error in pom.xml plugin
DigInG Knowledge Base
More like this
Docker Setup in Windows
Docker Setup in Windows
DigInG Knowledge Base
More like this
Missing SQL Tables from CORD19
Missing SQL Tables from CORD19
DigInG Knowledge Base
More like this