mysql:问号代替符号

r7knjye2  于 2021-06-21  发布在  Mysql
关注(0)|答案(1)|浏览(605)

我在mariadb中创建了一个数据库,然后运行一些sql来创建如下表:

create table customers
    ( customerid int unsigned not null auto_increment primary key,
      name char(50) not null,
      address char(100) not null,
      city char(30) not null
    );

    create table orders
    ( orderid int unsigned not null auto_increment primary key,
      customerid int unsigned not null,
      amount float(6,2),
      date date not null
    );

然后我尝试用一些数据填充它:

insert into customers values
  (3, "Саша Валентей", "12, ул. Гудвина", "г. Изумрудный"),
  (4, "Ева Легкая", "34, пр. Незнайки", "г. Солнечный"),
  (5, "Слава Моргунов", "56, пер. Поттера", "пгт Хогвартс");

insert into orders values
  (NULL, 3, 69.98, "2008-04-02"),
  (NULL, 1, 49.99, "2008-04-15"),
  (NULL, 2, 74.98, "2008-04-19"),
  (NULL, 3, 24.99, "2008-05-01");

是西里尔文,如果有关系的话。现在我有了问号我的角色应该在哪里。我的服务器是utf-8,那张table好像是拉丁语\瑞典语\ ci。我该怎么解决这个问题?

ep6jt1vc

ep6jt1vc1#

试试这个:

ALTER TABLE customers CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

相关问题