mysql problem : illegal mix of collations when join 2 table

Channel:
Ambar Hasbiyatmoko
Subscribers:
4,970
Published on ● Video Link: https://www.youtube.com/watch?v=XsGtiADNj4U


Duration: 1:19
3,537 views
7

how to solving #1267 - Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT)



Other Videos By Ambar Hasbiyatmoko


2015-12-30Apache problem : Could not reliably determine the server's fully qualified domain name
2015-12-29bootstrap problem - horizontal scrollbar in bottom page
2015-12-28suasana masjid nabawi jam 2 pagi - march 2014
2015-12-28install tilemill on ubuntu 14 04
2015-12-25datatables problem : cannot sort the numeric column
2015-12-22create tiles from image and show that tiles on leaflet map [part 2 - finishing]
2015-12-21create tiles from image and show that tiles on leaflet map [part 1] ~ georeferencing image with qgis
2015-12-21amcharts tutorial : change color piechart
2015-12-17chart js problem : multiple chart when mouse hover (ajax request)
2015-12-16mapnik problem : WARN This failure might be due to the use of legacy binary node
2015-12-15mysql problem : illegal mix of collations when join 2 table
2015-12-14postgresql error : FATAL Peer authentication authentication failed for user postgres
2015-12-14mapnik : working with shp + postgis and display the tiles on leaflet map [part 2]
2015-12-12node js error : Most middleware like compress is no longer bundled with Express
2015-12-07Tilemill error : cannot open tilemill on ubuntu 14 04
2015-12-04codeigniter problem : 500 Internal server error
2015-12-01tablesorter js problem : cannot sort the table from ajax request
2015-11-25leaflet : showing leaflet map in code igniter
2015-11-09code igniter problem : bootstrap cannot loaded
2015-11-03Phpmyadmin error : The json extension is missing
2015-11-03Virtualbox problem : can't share folder from windows 7 to ubuntu guest


Tags:
MySQL (Software)
join table
PhpMyAdmin (Software)