我在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。我该怎么解决这个问题?
1条答案
按热度按时间ep6jt1vc1#
试试这个: