logo

Répondre à : Message erreur synchro palette “SQLSTATE=42000”

Nicolas Filloleau
Nicolas Filloleau
Participant

Il est aussi possible de forcer l’encodage. J’imagine que le problème doit être dans un des libellés.
Vous pouvez essayer ça pour forcer les libellés en utf8 :

SELECT
o.valeurC1 AS orderRefs,r.*,
rp.*,
lsp.src_id AS idSsProd,
sp.o_parentId AS idProd,
p.src_id AS idProd2,
CONVERT(cr.libelleC1 USING utf8) “libelleC1”,
cr.valeurC1,
cr.uniteC1,
CONVERT(cr.libelleC2 USING utf8) “libelleC2”,
cr.valeurC2,
cr.uniteC2,
CONVERT(cr.libelleC3 USING utf8) “libelleC3”,
cr.valeurC3,
cr.uniteC3,
CONVERT(cr.libelleC4 USING utf8) “libelleC4”,
cr.valeurC4,
cr.uniteC4,
CONVERT(cr.libelleC5 USING utf8) “libelleC5”,
cr.valeurC5,
cr.uniteC5,
CONVERT(cr.libelleC6 USING utf8) “libelleC6”,
cr.valeurC6,
cr.uniteC6,
CONVERT(cr.libelleC7 USING utf8) “libelleC7”,
cr.valeurC7,
cr.uniteC7,
CONVERT(cr.libelleC8 USING utf8) “libelleC8”,
cr.valeurC8,
cr.uniteC8,
CONVERT(cr.libelleC9 USING utf8) “libelleC9”,
cr.valeurC9,
cr.uniteC9,
CONVERT(cr.libelleC10 USING utf8) “libelleC10”,
cr.valeurC10,
cr.uniteC10,
CONVERT(cr.libelleC11 USING utf8) “libelleC11”,
cr.valeurC11,
cr.uniteC11
FROM object_localized_8_de AS r
JOIN _refPhotos AS rp ON rp.idRef=r.oo_id
JOIN object_collection_catalogues_8 AS cat ON (cat.o_id=r.oo_id AND cat.libelle_catalogue LIKE “%Bovin%”)
LEFT JOIN carac_ref_de AS cr ON cr.oo_id=r.oo_id
LEFT JOIN object_relations_2 AS p ON (p.dest_id=r.oo_id AND p.fieldname = “refs_link”)
LEFT JOIN object_relations_9 AS lsp ON (lsp.dest_id = r.oo_id AND lsp.fieldname = “ss_prod_link”)
LEFT JOIN object_9 AS sp ON lsp.src_id = sp.oo_id
LEFT JOIN _order-ref-cosnet AS o ON r.oo_id=o.oo_id AND r.language = ‘de’
GROUP BY oo_id,idSsProd,idProd,idProd2

Facebook
Twitter