Ticket #59 (closed task: fixed)

Opened 6 years ago

Last modified 6 years ago

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

Changed 6 years ago by anonymous

  • cc None added
  • component changed from database to treeGDE
  • summary changed from MySQL character set for UTF-8? to None
  • priority changed from major to critical
  • owner changed from astrid to nimix
  • version 2.4.2 rc1 deleted
  • milestone set to Support usage of Styled Layer Descriptors (SLD)
  • keywords None added
  • type changed from defect to enhancement
Fine arts museum of san francisco Arts center macomb performing

Changed 6 years ago by christoph

  • component changed from treeGDE to database
  • summary changed from None to MySQL character set for UTF-8?
  • priority changed from critical to major
  • version set to 2.4.2 rc1
  • milestone Support usage of Styled Layer Descriptors (SLD) deleted
  • owner changed from nimix to astrid
  • type changed from enhancement to defect

Changed 6 years ago by christoph

  • type changed from defect to task

Changed 6 years ago by sven

  • status changed from new to closed
  • resolution set to fixed

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.