Unicode

Profile picture for user Guest

Was ist der Unterschied zwischen Mysql "utf8_general_ci" und "utf8_unicode_ci"

Ich programmiere gerade mit PHP ein Spiel und muss dafür des öfteren Datenbanktabellen erstellen und nehme jedesmal "utf8_general_ci". Vor kurzem wurde mir gesagt, dass diese Kollation nicht die beste sei, da einige Zeichen nicht unterstützt werden.

Kann mir bitte jemand verraten wo der Unterschied und Vorteil ist?

Subscribe to Unicode

Suche

Neueste Kommentare

  • Same with Drush 13 + PHP 8.3 and my Solution

    2 months ago
    [preflight] The following restricted PHP modes have non-empty values: {open_basedir}. This configuration is incompatible with drush.

    Same with Drush 13 + PHP 8.3

  • Error : Failed to install the required package 'RPM' by using AP

    2 months ago
    Acronis CyberProtect Agent For Linux (Strato Root Server)

    Initializing...

    Error : Failed to install the required package 'RPM' by using APT. Please install it manually. 

    Exit

    Solution:

  • Installieren & Aktivieren

    2 months ago
    Acronis CyberProtect Agent For Linux (Strato Root Server)

    So habe es installiert und dann mit Hilfe von Key/Code (über Website von Acronis Cyber Protect) aktiviert:

  • I have a view with a path…

    2 months ago
    No route found for the specified format html. Supported formats: csv, json. (Drupal Routing)

    I have a view with a path like

    /my-content-export
    to export entivies as JSON or CSV.

  • admin_toolbar 3.5.2 is the…

    2 months 1 week ago
    InvalidArgumentException: The controller for URI "/admin/flush" is not callable.

    admin_toolbar 3.5.2 is the reason. Patch coming ...

  • Drupal 10.4, in a custom View

    3 weeks 4 days ago
    PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock

    Drupal 10.4:

  • Tools & Settings >> Security…

    3 months ago
    Server install & config : Debian 12 + Plesk + Apache + nginx + MariaDB + Solr

    Tools & Settings >> Security Policy :

     Allow only secure FTPS connections 

  • List config vaiables

    4 months 2 weeks ago
    MariaDB Server Performance Optimieren

     

    /usr/sbin/mariadbd --help --verbose | grep "query.*size"

  • Restart MariaDB / MySQL

    4 months 2 weeks ago
    MariaDB Server Performance Optimieren

    Commandline:

    systemctl restart mariadb

  • MariaDB Restart (after changes in /etc/mysql/db-performance.cnf)

    4 months 2 weeks ago
    MariaDB Server Performance Optimieren

    After my changes in /etc/mysql/db-performance.cnf