Hi to all
What basic adjustments must I use when I would like to crate the databse by PhpMyAdmin
*
I have two possible choices
first to creat the database -> Kollation…utf8_????
and additional:
Character Set: Kollation of the MySql Connection -> utf_bin …utf_???
Kind Regards Knut
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I don't understand your question because of the awkward phrasing through the use of '???,' random italics, and such. I'd create a UTF8 database. Please also refer to: . Is there a reason you cannot use install.php?
depending on whether you'd like to install refbase as a Unicode/UTF8-based database, or with Western ISO Latin 1 (aka ISO-8859-1) encoding:
ISO-8859-1:
`default character set: latin1
collation: latin1_general_ci`
Unicode/UTF-8:
`default character set: utf8
collation: utf8_general_ci`
If possible, set all "levels" (i.e. server, database, connection, etc) to either utf8 or latin1, and try to avoid mixing encodings.
Using raw MySQL, if you've decided to name your new database literature and use the Unicode character set (UTF8 encoding) for your database, your CREATE DATABASE statement would read:
CREATE DATABASE literature DEFAULT CHARACTER SET utf8;
The reason is, that I have a lot of erros in the present database.
Nearly all special characters are corrupted, after doing an phpMyAdmin dump and inport with PhP MyAdmin.
Therefore I changed all wrong character with an Text edtior, and have now an (with the Editor) SQL File.
Because of that I think that I did the basic set of the database wrong.
Is it right in that case to create the dabase befor importing the sql file with:
CREATE DATABASE literature DEFAULT CHARACTER SET utf8;
default character set: utf8 collation: utf8_general_ci
Regards Knut
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi to all
What basic adjustments must I use when I would like to crate the databse by PhpMyAdmin
*
I have two possible choices
first to creat the database -> Kollation…utf8_????
and additional:
Character Set: Kollation of the MySql Connection -> utf_bin …utf_???
Kind Regards Knut
I don't understand your question because of the awkward phrasing through the use of '???,' random italics, and such. I'd create a UTF8 database. Please also refer to: . Is there a reason you cannot use install.php?
: http://www.refbase.net/index.php/Manual_installation
Hi Knut,
depending on whether you'd like to install refbase as a Unicode/UTF8-based database, or with Western ISO Latin 1 (aka ISO-8859-1) encoding:
ISO-8859-1:
`default character set: latin1
collation: latin1_general_ci`
Unicode/UTF-8:
`default character set: utf8
collation: utf8_general_ci`
If possible, set all "levels" (i.e. server, database, connection, etc) to either utf8 or latin1, and try to avoid mixing encodings.
Using raw MySQL, if you've decided to name your new database literature and use the Unicode character set (UTF8 encoding) for your database, your CREATE DATABASE statement would read:
CREATE DATABASE literature DEFAULT CHARACTER SET utf8;
You might also want to take a look at:
(http://www.refbase.net/index.php/Manual_installation#2_Installing_refbase_on_your_own_server)
HTH, Matthias
The reason is, that I have a lot of erros in the present database.
Nearly all special characters are corrupted, after doing an phpMyAdmin dump and inport with PhP MyAdmin.
Therefore I changed all wrong character with an Text edtior, and have now an (with the Editor) SQL File.
Because of that I think that I did the basic set of the database wrong.
Is it right in that case to create the dabase befor importing the sql file with:
CREATE DATABASE literature DEFAULT CHARACTER SET utf8;
default character set: utf8 collation: utf8_general_ci
Regards Knut
Hi Matthias,
unfortunately PhpMyAdmin does not allow to use Create Commands in the SQL window.
Therefore I must use PhPMy Admin to create the database:
see (German) <br>
http://uni-regensburg.equine-behaviour.de/tmp/database1.jpg<br>
http://uni-regensburg.equine-behaviour.de/tmp/database2.jpg<br>
Could you tell me what I must use from the pull down menues?
Regards Knut
Hi Knut,
for a UTF-8 based database, use `utf8_general_ci` in both cases (i.e. for the database collation as well as for the server's connection collation).
HTH, Matthias