-
Type: Task
-
Resolution: Fixed
-
Priority: Critical
-
Affects Version/s: None
-
Component/s: CLI: pegasus-db-admin
-
None
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;