SELECT @i1:=LOCATE('\\X2',IfcData)i1,@i2:=LOCATE('\\X0',IfcData)i2,COUNT(*),
SUBSTR(IfcData,@i1+4,@i2-@i1-4),IfcData
FROM ifc_BimCon_01 WHERE LOCATE('\\X2',IfcData)>0 GROUP BY SUBSTR(IfcData,@i1+4,@i2-@i1-4) LIMIT 50;

UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\0160\\X0\\',' ');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\00DD\\X0\\','Ý');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\00CD\\X0\\','Í');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\017D\\X0\\','Ž');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\00D3\\X0\\','Ó');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\011A\\X0\\','Ě');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\0158\\X0\\','Ř');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\00C1\\X0\\','Á');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\00DA\\X0\\','Ú');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\00C10160\\X0\\','ÁŠ');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\00C9\\X0\\','É');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\00E1\\X0\\','á');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\00E9\\X0\\','é');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\00ED\\X0\\','í');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\00FD\\X0\\','ý');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\00E101610165\\X0\\','ášť');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\010C\\X0\\','Č');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\010C00C1\\X0\\','ČÁ');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\010C00CD\\X0\\','ČÍ');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\010D\\X0\\','č');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\010D00E1\\X0\\','čá');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\011B\\X0\\','ě');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\0148\\X0\\','ň');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\015800CD\\X0\\','ŘÍ');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\0147\\X0\\','Ň');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\0159\\X0\\','ř');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\015900ED\\X0\\','ří');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\015900ED0148\\X0\\','říň');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\0161\\X0\\','š');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\01610165\\X0\\','šť');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\016E\\X0\\','Ů');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\016F\\X0\\','ů');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\017D00C1\\X0\\','Ž');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\017E\\X0\\','ž');
UPDATE ifc_BimCon_01 SET IfcData=REPLACE(IfcData,'\\X2\\017E00E1\\X0\\','žá');

