Upgrade Pegasus Databases to be Unicode Compatible

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

XMLWordPrintable

      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;

            Assignee:
            Rafael Ferreira Da Silva [X] (Inactive)
            Reporter:
            Rajiv Mayani
            Archiver:
            Rajiv Mayani

              Created:
              Updated:
              Resolved:
              Archived: