Opened 18 years ago
Closed 17 years ago
#59 closed task (fixed)
MySQL character set for UTF-8?
| Reported by: | christoph | Owned by: | astrid |
|---|---|---|---|
| Priority: | major | Milestone: | |
| Component: | database | Version: | 2.4.2 rc1 |
| Keywords: | None | Cc: | None |
Description
The standard character set in MySQL for UTF-8 is
utf8_general_ci
where ci means "case insensitive". There are some tables that have keys that are case sensitive: "keyword" for example has an entry "land" and an entry "Land". So importing this dump in MySQL fails.
For ISO8859-1 there is a case sensitive encoding
latin1_general_cs
Change History (4)
comment:1 by , 18 years ago
| Cc: | added |
|---|---|
| Component: | database → treeGDE |
| Keywords: | None added |
| Milestone: | → Support usage of Styled Layer Descriptors (SLD) |
| Owner: | changed from to |
| Priority: | major → critical |
| Summary: | MySQL character set for UTF-8? → None |
| Type: | defect → enhancement |
| Version: | 2.4.2 rc1 |
Fine arts museum of san francisco Arts center macomb performing
comment:2 by , 18 years ago
| Component: | treeGDE → database |
|---|---|
| Milestone: | Support usage of Styled Layer Descriptors (SLD) |
| Owner: | changed from to |
| Priority: | critical → major |
| Summary: | None → MySQL character set for UTF-8? |
| Type: | enhancement → defect |
| Version: | → 2.4.2 rc1 |
comment:3 by , 17 years ago
| Type: | defect → task |
|---|
comment:4 by , 17 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
To resolve the problem create a database like this:
CREATE DATABASE mapbender DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
Now the database/tables are case sensitive.
It is changed in the Mapbender Wiki under installation (en and de)
Note:
See TracTickets
for help on using tickets.
