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

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:
            rafsilva Rafael Ferreira Da Silva (Inactive)
            Reporter:
            mayani Rajiv Mayani
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: