Creation of database: collation?

Question

Creation of database: collation?

torvista opened this issue 4 years ago · 6 comments

Open your hosting account's control panel.
Find the "Databases" section
Choose the MySQL option
Click on the option to Create a database. Enter a name for it and submit. (Record the name for use in Zen Cart)

Why no mention of collation or character sets?

In the ZC fileset docs for installation, it goes in great detail through the installer steps until the point where it mentions that the database should have been previously created....I think that should be mentioned before the installer as that immediately stops the process and sends the user off in another direction. But it is not mentioned at all and again omits anything about collation/characters sets.

Answer 1 · 2021-03-17T22:54:52.000Z

Please submit a PR.

Answer 2 · 2021-03-18T09:35:24.000Z

I don't mind writing it...but to say what exactly?

Answer 3 · 2021-03-18T11:24:54.000Z

I thought you were wanting to add content on collation and character sets?

But the placement you suggested seems wrong - when you are in cPanel creating a database, you just pick a name, you don't set the collation or character set.

Answer 4 · 2021-03-18T11:28:51.000Z

Sure, but should you not subsequently set what you want to use in phpmyadmin before installing?

Answer 5 · 2021-03-18T11:40:19.000Z

Why ? If you use the defaults, it does what is desired.

Answer 6 · 2021-03-18T18:05:47.000Z

I made this update yesterday in response to this discussion: 00dd3df
However, I too am not convinced this is the best place for it, particularly because this area reads more like how to create a database in cPanel, which as Scott mentions is an extremely generic action.