Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
6 registered (ChevyGuy, Djuma, DougMM, Pink Jazz, Thelockman, 1 invisible), 22 Guests and 24 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 11/02/08
Posts: 2
Top Posters (30 Days)
Ruben Rocha 179
Gizmo 112
Rick 109
Thelockman 80
driv 43
AllenAyres 35
ntdoc 28
Ian 24
Sirdude 23
ScriptKeeper 20
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
Topic Options
Rate This Topic
#195920 - 08/31/07 08:25 AM Database encoding fix
nims2 Offline
journeyman

Registered: 07/04/07
Posts: 76
Whenever you import an old UBB classic, it can happen that you see weird texts like:

€ or ‘ instead of é or ë

This SQL scripts updates all the incorrect posts in your database so that after this, everything will goes fine as it should.

Have fun with it, and use it at your own risk! Enter this is your PHPMyadmin for Mysql to run it:
 Code:
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 '%”“%'
;


Top
#196095 - 09/02/07 10:46 PM Re: Database encoding fix [Re: nims2]
AllenAyres Moderator Offline

****

Registered: 12/29/03
Posts: 1639
Loc: Texas
Thank you - I seem to remember having some of those issues with my classic import, this didn't find anything, but mebbe it was another board \:\)
_________________________
- Allen
- ThreadsDev | PraiseCafe

Top


Shout Box

Today's Birthdays
brushie, cass, Monte G., twebman, White Gold Wielder
Recent Topics
Shrinking graemlins
by Djuma
Today at 05:48 PM
2 problems I'm seeing now.
by DougMM
Today at 04:39 PM
Which CSS Style Controls the bottom lines
by David DelMonte
Today at 01:51 PM
UBBThreads vs. vBulletin -- Defections & Why So Tough to Compare?
by WebMagic
Today at 12:28 PM
Font and column shifts occuring
by Bill B
Yesterday at 06:21 PM
Forum Stats
4261 Members
33 Forums
30532 Topics
154960 Posts

Max Online: 978 @ 06/24/07 08:19 PM