Wie kann es sein, dass ein Select geht:
SELECT w.LicPlate, w.validfrom, w.validto, loc.* --u., r.
FROM whitelist w
join reason r on r.ID = w.reasonID
join .sers u on u.ID = r.userID
join locations loc on loc.location_id = SUBSTR(u.vorname,13,10);
Create View:
CREATE OR REPLACE VIEW allWhiteLists AS
SELECT w.LicPlate, w.validfrom, w.validto, loc.* --u., r.
FROM whitelist w
join reason r on r.ID = w.reasonID
join .sers u on u.ID = r.userID
join locations loc on loc.location_id = SUBSTR(u.vorname,13,10);
Select auf der VIEW schlägt dann fehl
select * from allWhiteLists;
->
Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
SQLState: HY000
ErrorCode: 1267
SELECT w.LicPlate, w.validfrom, w.validto, loc.* --u., r.
FROM whitelist w
join reason r on r.ID = w.reasonID
join .sers u on u.ID = r.userID
join locations loc on loc.location_id = SUBSTR(u.vorname,13,10);
Create View:
CREATE OR REPLACE VIEW allWhiteLists AS
SELECT w.LicPlate, w.validfrom, w.validto, loc.* --u., r.
FROM whitelist w
join reason r on r.ID = w.reasonID
join .sers u on u.ID = r.userID
join locations loc on loc.location_id = SUBSTR(u.vorname,13,10);
Select auf der VIEW schlägt dann fehl
select * from allWhiteLists;
->
Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
SQLState: HY000
ErrorCode: 1267