Error in getting entries

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'

Query: SELECT title as title,timestamp as date, entry as entry, author as author, commentid as commentid, articleid as articleid, country as country, location as location, tags as tags from articles WHERE articleid LIKE '%' AND commentid = '0' AND country LIKE 'Germany' AND location LIKE 'Sch��nhagen%' AND timestamp BETWEEN '2001-01-01 00:00:00 ' AND ' 2050-12-31 23:59:59 ' ORDER BY articleid DESC LIMIT 5 OFFSET 0

• ...older

browse by location

Sweden

• Stockholm (1)

Germany

• Sassnitz (1)
• Schwedt (1)
• Vohburg (1)

Austria

• Lech (1)

Lichtenstein

• Vaduz (1)

Switzerland

• Basel (1)

Germany

• Erlenbach bei Dahn (1)

Luxembourg

• Schengen (1)

Belgium

• Martelange (1)

France

• Felleries (1)
• Saint-Omer (1)

Iceland

• Reykjavik (1)
• Vik (1)
• Skogar (1)
• Landmannalauger (1)
• Hnottottaalda (1)
• Gaestavatn (1)
• Askja (1)
• Lake Myvatn (1)
• Asbyrgi (1)

Slovenia

• Kranj (1)
• Skocjan (1)
• Ljubljana (1)
• Tolmin (1)
• Bohinj (1)
• Solcava (1)
• Maribor (1)

Hungary

• Keszthely (1)
• Budapest (1)

Slovakia

• Bojnice (1)

Hungary

• Kecskemet (1)
• Eger (1)
• Aggletek (1)

Slovakia

• Kosice (1)

Poland

• Chocholow (1)

Slovakia

• Poprad (1)
• Muran (1)
• Banska Stiavnica (1)
• Martin (1)

Poland

• Zakopane (1)
• Krakow (1)
• Opole (1)

Czech Republic

• Broumov (1)

Poland

• Wroclaw (1)

Czech Republic

• Teplice (1)
• Harrachov (1)
• Cesky Raj (1)
• Humpolec (1)
• Mikulov (1)
• Brno (1)
• Olomouc (1)
• Moravia (1)
• Svitavy (1)
• Prague (2)

England

• Kent (1)

Thaliand

• Similian Islands (1)

Hong Kong

• Hong Kong (1)

Thailand

• Phuket (1)

RSA

• Durban (1)
• Umkomaas (1)
• Sani Pass (2)
• Royal Natal (1)
• Johannesburg (1)

Zimbabwe

• Victoria Falls (1)
• Bulawayo (1)
• Gweru (1)
• Chimanimani (1)
• Harare (1)

Malawi

• Lilongwe (1)

Tanzania

• Stone Town (1)
• Marangu (1)

Kenya

• Masai Mara (1)

Tanzania

• Musoma (1)

Rwanda

• undefined (1)

Uganda

• Kabale (1)
• Kampala (1)
• Busia (1)

Kenya

• Lake Naivasha (1)
• Nairobi (1)

Norway

• Bergen (1)
• Odda (1)
• Ryfylke (1)
• Stavanger (1)
• Egersund (1)
• Kristiansand (1)
• Vråvatn (1)
• Gaustatoppen (1)
• Oslo (1)

Sweden

• Tanumshede (1)
• Gothenburg (1)
• Fjaras Kyrkby (1)

Denmark

• Elsinore (1)
• Soro (1)
• Horsens (1)
• Aarhus (1)
• Hobro (1)
• Hanstholm (1)
• Ribe (1)

Germany

• Schönhagen (1)
• Berlin (2)
• Hamburg (2)
• Bremen (1)
• Cuxhaven (1)

The Netherlands

• Oldambt (1)
• The Hague (2)
• Gelderland (1)
• Hellevoetsluis (1)
• Zeeland (1)
• Utrecht (1)

Cuba

• Vinales (1)
• Trinidad (1)
• Havana (2)

Cayman Islands

• Grand Cayman (2)

France

• Les Houches (1)

Switzerland

• Col de Forclaz (1)

Italy

• Courmayeur (1)

Switzerland

• Geneva (1)

England

• Oxfordshire (1)

Wales

• Brecon Beacons (1)
• conwy (2)
• Rhinogs (1)
• Snowdonia (1)
• Commins Coch (1)
• Glyntawe (1)
• Crickhowell (1)
• Abergavenny (4)
• Risca (1)
• Cardiff (1)

Scotland

• John o Groats (1)
• Thurso (1)
• Durness (1)
• Inchnadamph (2)
• Shiel Bridge (1)
• Fort William (1)
• Loch Lochy (2)
• Inverness (1)
• Cairngorms (2)
• Anstruther (1)
• Aberdour (1)
• Livingston (1)
• Melrose (1)
• Kirk Yelthom (1)

England

• Scottish Borders (1)
• Alston (2)
• Yorkshire (6)
• derbyshire (3)
• Staffordshire (1)
• Warwickshire (4)
• Gloucestershire (1)
• Devon (1)
• Cornwall (6)
• Richmond (1)

France

• Tignes (10)
• les arcs (2)

Holland

• Amsterdam (1)

England

• Robin Hoods Bay (2)
• Lake District (2)

Germany

• Munich (1)

England

• North Yorkshire (4)

USA

• Baltimore (1)
• Albany (2)
• Miami (1)
• Cape Canaveral (2)
• Stuart (2)
• Harpers Ferry (2)
• Fort Lauderdale (5)
• Maine (1)

England

• Melsonby (10)

Thailand

• Bangkok (2)
• Koh Tao (1)
• Koh Phangen (1)

Malaysia

• Perhentian Islands (2)
• Perhentian Kecil (1)

Singapore

• Singapore (1)

Fiji

• Nadi (1)

Australia

• Melbourne (1)

Samoa

• Apia (2)

Fiji

• Taveuni (1)

Australia

• Sydney (4)

New Zealand

• Wellington (1)
• Taupo (2)
• Northland (1)
• Paihia (1)
• Whangarei (1)
• Auckland (4)

Cook Islands

• Rarotonga (2)

Mexico

• Mexico City (1)
• Playa Del Carmen (4)

USA

• Tucson (4)
• San Diego (5)
• Santa Barbara (1)
• Monterey (1)
• Santa Cruz (2)
• Salt Lake City (2)
• Death Valley (1)
• Las Vegas (1)
• Yosemite (1)
• San Francisco (9)
• Eureka (1)
• Crescent City (3)
• Crater Lake (1)
• Ashland (2)
• Eugene (1)
• Portland (4)
• Seattle (3)

Canada

• Whistler (1)
• Vancouver (5)
• Fort McMurray (1)
• Edmonton (1)
• Winnipeg (3)
• Toronto (5)
• Kingston (1)

USA

• Chicago (2)
• Washington DC (2)
• Virgina (1)
• Philadelphia (1)
• New York (8)
• New Hampshire (11)
• Boston (7)

England

• London (4)
• Nottingham (23)
• my flat (9)

• (7)