[ postfixadmin-Bugs-1972703 ] utf-8 problem in different tables fields

[SourceForge.net <no...@so...>]

Bugs item #1972703, was opened at 2008-05-26 13:25
Message generated for change (Comment added) made by christian_boltz
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1972703&group_id=191583

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
>Category: Database
Group: None
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: utf-8 problem in different tables fields

Initial Comment:
Almost all the tables created by upgrade.php have LATIN1 codepage, thus it's impossible give the description in utf-8 codepage in domain table, for example.

I think the right behavior is that all of the tables should be utf-8 by default.

 

----------------------------------------------------------------------

>Comment By: Christian Boltz (christian_boltz)
Date: 2008-05-26 23:09

Message:
Logged In: YES 
user_id=593261
Originator: NO

The correct behaviour is:
- have utf8 for all fields where the user can enter any text (description,
vacation message etc)
- have latin1 for domains and mail addresses - they will never contain
non-ascii characters (special characters have to be punicode-encoded in
domain names)
- and, most important: use latin1 whenever possible. utf8 can cause
various problems (for example with index length limits), therefore it
should only be used if really necessary.

I just checked the database. The following fields need to be changed to
utf8:
- domain.description
- mailbox.name
- (vacation message is already utf-8)

I just added the needed ALTER TABLE statements to upgrade.php. Please run
setup.php to update your database.

-> Fixed in SVN r374 - thanks for your report!

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1972703&group_id=191583