Page 1 of 1
_DB_NOT_UTF8
Posted: Mon Aug 27, 2018 10:06 pm
by gihel
Hi everybody
I don't understand. My BD is utf8_unicode
I already installed formalms on the same host and all was right and now there is problem
Have you an idea about the bug ?
Re: _DB_NOT_UTF8
Posted: Tue Aug 28, 2018 8:51 am
by canelli
Please share more information in your issue and configuration.
during installation and upgrade , formalms checks the database default charset that must be UTF8 .
Re: _DB_NOT_UTF8
Posted: Tue Aug 28, 2018 11:20 am
by gihel
When I put the hostname into
address and database name I have the message : db will be created but if I click the next step the process turn one hour for nothing
if I put the real database name into database name it say not utf
address must be hostname and database name must be the name of database, isn't ??????
my DB configuration =
Serveur : db751359211.db.1and1.com via TCP/IP
Type de serveur : MySQL
Version du serveur : 5.5.60-0+deb7u1-log - (Debian)
Version du protocole : 10
Utilisateur :
[email protected]
Jeu de caractères du serveur : UTF-8 Unicode (utf8)
thank you for help
Re: _DB_NOT_UTF8
Posted: Tue Aug 28, 2018 2:20 pm
by canelli
I have the message : db will be created but if I click the next step the process turn one hour for nothing
the mysql user specified in the form must have "create privilege" as general privilege to create a database.
Jeu de caractères du serveur : UTF-8 Unicode (utf8)
this is not the database charset , is the general default of the mysql server
the database that you want to use must be set with UTF.8 charset
you can use the following mysql statement with a mysql command line tool
Code: Select all
CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;
ù
or , if you use a phpmyadmin tool , create the db as in the following img:
or change the charset / collaction in the "operations" tab
Re: _DB_NOT_UTF8
Posted: Tue Aug 28, 2018 5:02 pm
by gihel
Thank you very much
It's OK now
Congratulations