How to create database via sql and utf8_bin?

0

I have the following sql script:

CREATE TABLE IF NOT EXISTS 'pais' (
'id' int(11) NOT NULL AUTO_INCREMENT,
'nome' varchar(60) DEFAULT NULL,
'sigla' varchar(10) DEFAULT NULL,
PRIMARY KEY ('id')
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO 'pais' ('id', 'nome', 'sigla') VALUES (1, 'Brasil', 'BR');


CREATE TABLE IF NOT EXISTS 'estado' (
  'id' int(11) NOT NULL AUTO_INCREMENT,
  'nome' varchar(75) DEFAULT NULL,
  'uf' varchar(5) DEFAULT NULL,
  'pais' int(7) DEFAULT NULL,
  PRIMARY KEY ('id'),
  KEY 'fk_Estado_pais' ('pais')
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;


INSERT INTO 'estado' ('id', 'nome', 'uf', 'pais') VALUES
(1, 'Acre', 'AC', 1),
(2, 'Alagoas', 'AL', 1),
(3, 'Amazonas', 'AM', 1),
(4, 'Amapá', 'AP', 1),
(5, 'Bahia', 'BA', 1),
(6, 'Ceará', 'CE', 1),
(7, 'Distrito Federal', 'DF', 1),
(8, 'Espírito Santo', 'ES', 1),
(9, 'Goiás', 'GO', 1),
(10, 'Maranhão', 'MA', 1),

As you can see, I put CHARSET = utf8 and it generates a database with utf8_general_ci. I need it to be, just utf8_bin. I've tried putting utf8_bin in the script, but it points to a syntax error and says that it ignores utf8_bin. Does anyone know how I can do this?

    
asked by anonymous 13.01.2016 / 19:25

0 answers