Bug #7655

Database created in Latin1 mode

Added by Michiel Roos about 3 years ago. Updated over 2 years ago.

Status:Closed Start date:2010-05-05
Priority:Must have Due date:
Assignee:- % Done:

0%
Category:Install process
Target version:Release of TYPO3 4.4.0
Votes: 0

Description

The installer creates a database with Latin1 caharacter set as default.

mysql> show create database intro;
--------------------------------------------------------------------------+ | Database | Create Database |
--------------------------------------------------------------------------+ | intro | CREATE DATABASE `intro` /*!40100 DEFAULT CHARACTER SET latin1 */ |
--------------------------------------------------------------------------+
1 row in set (0.01 sec)

This should look like:
mysql> show create database intro;
------------------------------------------------------------------------+ | Database | Create Database |
------------------------------------------------------------------------+ | intro | CREATE DATABASE `intro` /*!40100 DEFAULT CHARACTER SET utf8 */ |
------------------------------------------------------------------------+
1 row in set (0.00 sec)

Which is the result of creating a database using: CREATE DATABASE intro CHARACTER SET utf8 COLLATE utf8_general_ci;

History

#1
Updated by Oliver Hader about 3 years ago

  • Category set to Install process
  • Status changed from New to Needs Feedback
  • Target version set to Release of TYPO3 4.4.0

But this depends on the default character set of the database where the package shall be installed.
However, I think we can/must assume that UTF-8 is available at that server and could define the "SET NAMES UTF8" for the connection. What do you think?

#2
Updated by Michiel Roos about 3 years ago

Yes, I agree that we should assume that UTF-8 is available in mysql and should attempt to create a full UTF-8 db.

#3
Updated by Peter Beernink about 3 years ago

I also agree, however that probably should be changed in the install tool itself, as I believe the introduction package kicks in after that step.

#4
Updated by Michiel Roos about 3 years ago

If you are 'sure of it' we can close this bug and open a new one in core.

#5
Updated by Michiel Roos about 3 years ago

  • Status changed from Needs Feedback to Closed

Won't fix, is an install tool issue . . .

Plese create a bug report there.

#6
Updated by Michiel Roos about 3 years ago

Ok, this issue lives on as: http://bugs.typo3.org/view.php?id=14787

Also available in: Atom PDF