Uploaded image for project: 'Pegasus'
  1. Pegasus
  2. PM-1413

Upgrade Pegasus Databases to be Unicode Compatible

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: master, 5.0.0
    • Component/s: CLI: pegasus-db-admin
    • Labels:
      None

      Description

      Pegasus database schemas are using latin1 charset, which does not support unicode characters. We will need to change them to support UTF-8.


      sqlite does not seem to be impacted

      sqlite> create table a ( a varchar(10) );
      sqlite> insert into a values ( '学中文' );
      sqlite> select * from a;
      学中文

      MySQL/PostgreSQL would need fixing

      create database a CHARACTER SET latin1;
      use a;
      create table a ( a varchar(10) ) CHARACTER SET latin1;
      insert into a values ( '学中文' ); -- Fails
      select * from a;
      create table b ( a varchar(10) ) CHARACTER SET utf8mb4;
      insert into b values ( '学中文' );
      select * from b;

        Attachments

          Activity

            People

            • Assignee:
              rafsilva Rafael Ferreira Da Silva
              Reporter:
              mayani Rajiv Mayani
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: