Questions and discussions

Correct charset in phpMyAdmin?

Script's setup and configuration

Correct charset in phpMyAdmin?

Postby mj72 » Wed Oct 16, 2019 1:04 pm

I am uploading danish photos in UTF-8.

In my webhost > Controlpanel > table photos > Tab Structure: Here there are charset for: title, description, keywords, author, content type, color, refuse_reason, url, url_jpg+png+gif+raw+tiff+eps+jp2+jpf+zip.

1. Should they all be: latin1_danish_ci, utf8mb4_danish_ci or uft8mb4_unicode_ci?

2. At PhpMyAdmin frontpage > Generel settings > Servers connetion charset: Is set to uft8mb4_unicode_ci
Is that correct?

Thanks a lot :-)
Posts: 96
Joined: Sat Jan 10, 2015 10:55 am

Re: Correct charset in phpMyAdmin?

Postby mj72 » Tue Nov 30, 2021 6:36 pm

This seems to work:
Changed in phpmyadmin > phpmyadmin > photo > structure: Changed title + description + url to uft8-danish.

- warning: Do NOT set a field to latin1_danish. And THEN in admin > media archive > select file(s) > action at the bottom: Recreate urls...: As soon as there is a æ, ø or then the rest of the description field is empty.

This also worked:
Opened the relevant php-files in Dreamweaver > Modify > Page Properties > Title/Encoding > Encoding: Unicode (UTF-8). And Unicode Normalization Form: D (Canonical Decomposition) > OK.

Posts: 96
Joined: Sat Jan 10, 2015 10:55 am

Return to Configuration

Who is online

Users browsing this forum: No registered users and 4 guests

  Photo Store Script

Professional php photo stock script and WordPress plug-in for photographers and video producers.

  CMSaccount Inc.