UBB.threads PHP Forum Software Community Forums UBB.threads 7 Importer Support Database encoding fix

UPDATE `ubbt_POSTS`
SET 
`POST_BODY`=( REPLACE (`POST_BODY`, '’', '''')),
`POST_DEFAULT_BODY`=( REPLACE (`POST_DEFAULT_BODY`, '’', ''''))
WHERE `POST_BODY` like '%’%'
;

UPDATE `ubbt_POSTS`
SET 
`POST_BODY`=( REPLACE (`POST_BODY`, 'ë', 'ë')),
`POST_DEFAULT_BODY`=( REPLACE (`POST_DEFAULT_BODY`, 'ë', 'ë'))
WHERE `POST_BODY` like '%ë%'
;

UPDATE `ubbt_POSTS`
SET 
`POST_BODY`=( REPLACE (`POST_BODY`, 'é', 'é')),
`POST_DEFAULT_BODY`=( REPLACE (`POST_DEFAULT_BODY`, 'é', 'é'))
WHERE `POST_BODY` like '%é%'
;

UPDATE `ubbt_POSTS`
SET 
`POST_BODY`=( REPLACE (`POST_BODY`, '“', '“')),
`POST_DEFAULT_BODY`=( REPLACE (`POST_DEFAULT_BODY`, '“', '“'))
WHERE `POST_BODY` like '%“%'
;

UPDATE `ubbt_POSTS`
SET 
`POST_BODY`=( REPLACE (`POST_BODY`, '‘', '”')),
`POST_DEFAULT_BODY`=( REPLACE (`POST_DEFAULT_BODY`, '‘', '”'))
WHERE `POST_BODY` like '%‘%'
;

UPDATE `ubbt_POSTS`
SET 
`POST_BODY`=( REPLACE (`POST_BODY`, 'â€', '”')),
`POST_DEFAULT_BODY`=( REPLACE (`POST_DEFAULT_BODY`, 'â€', '”'))
WHERE `POST_BODY` like '%â€%'
;

UPDATE `ubbt_POSTS`
SET 
`POST_BODY`=( REPLACE (`POST_BODY`, '”¦', '!')),
`POST_DEFAULT_BODY`=( REPLACE (`POST_DEFAULT_BODY`, '”¦', '!'))
WHERE `POST_BODY` like '%”¦%'
;

UPDATE `ubbt_POSTS`
SET 
`POST_BODY`=( REPLACE (`POST_BODY`, 'ï', 'ï')),
`POST_DEFAULT_BODY`=( REPLACE (`POST_DEFAULT_BODY`, 'ï', 'ï'))
WHERE `POST_BODY` like '%ï%'
;

UPDATE `ubbt_POSTS`
SET 
`POST_BODY`=( REPLACE (`POST_BODY`, 'Ã', 'ì')),
`POST_DEFAULT_BODY`=( REPLACE (`POST_DEFAULT_BODY`, 'Ã', 'ì'))
WHERE `POST_BODY` like '%Ã%'
;

UPDATE `ubbt_POSTS`
SET 
`POST_BODY`=( REPLACE (`POST_BODY`, '€', '€')),
`POST_DEFAULT_BODY`=( REPLACE (`POST_DEFAULT_BODY`, '€', '€'))
WHERE `POST_BODY` like '%€%'
;

UPDATE `ubbt_POSTS`
SET 
`POST_BODY`=( REPLACE (`POST_BODY`, '”“', '"')),
`POST_DEFAULT_BODY`=( REPLACE (`POST_DEFAULT_BODY`, '”“', '"'))
WHERE `POST_BODY` like '%”“%'
;