Project

General

Profile

Actions
Copy link

Bug #14765

closed

fresh install 3.8.0: tables are created with collation "latin1_swedish_ci"

Added by old_gizzmo66 about 19 years ago. Updated almost 18 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Karsten Dambekalns
Category:
Install Tool
Target version:
-
Start date:
2005-05-28
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
3.8.0rc1
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Fresh installation create all tables with collation "latin1_swedish_ci".

Questions:

Why they are created with this collation?
Can I change the collation to the system connection value
"utf8_general_ci"?

Environment:
Linux suse93 2.6.11.4-20a-default
MySQL 4.1.10a
PHP Version 4.3.10
Apache/2.0.53 (Linux/SUSE)
Typo3 3.8.0 (source+dummy)

MySQL default
Language : English (en-utf-8)
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_general_ci
(issue imported from #M1121)

Actions
Copy link
 #1

Updated by Karsten Dambekalns about 19 years ago

They are created without any specific collation, so MySQL uses the default one (which obviously is latin1_swedish_ci. You should be able to change it without any side-effects.

Actions
Copy link
 #2

Updated by Karsten Dambekalns over 18 years ago

To make your tables use your preferred collation, create or alter the database to use the one you need.
CREATE DATABASE db_name
[[DEFAULT] CHARACTER SET charset_name]
[[DEFAULT] COLLATE collation_name
or
ALTER DATABASE db_name
[[DEFAULT] CHARACTER SET charset_name]
[[DEFAULT] COLLATE collation_name]

Actions
Copy link
 #3

Updated by Karsten Dambekalns over 18 years ago

Or are you creating the database from within the install tool?

Actions
Copy link

Also available in: Atom PDF