Collation problem in MySQL

Navigation
0

I have a database in MySQL with respective data spread over tables. The database is already created and I have a problem that does not read the characters well as:

  • tildes
  • accents
  • ñ

    • What happens?

    I have tried to make the following sentences but it is not solved: I have tried the following sentences without luck: 

    ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

    Annotations

    The database is defined as follows:

    Display example:

        
    asked by omaza1990 20.02.2018 в 14:12
    source

    1 answer

    0

    If you want to take the field as it comes, you can treat your column as if it were binary or blob .

    Something like: 

    select [nombre_campo] **like binary** from [nombre_table]
        
    answered by 20.02.2018 в 14:44
    I have problems with the DefaultTableModel class in java Problems in the ASPxSpinEdit control in Internet explorer VB