Upgrade Pegasus Databases to be Unicode Compatible

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 (Inactive)
            Reporter:
            Rajiv Mayani
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: