:: Forums ⇒

#16: Re: u8tf Encoding Problem After upgrade Author: PartyMarty,

Posted: Fri Dec 29, 2006 4:37 pm
----
So does that mean I have go through the a search and replace ÃƒÂ � with the correct character or is there a function which does this automatically?

#17: Re: u8tf Encoding Problem After upgrade Author: NanoCaiordo, Location: Melbourne, AU

Posted: Fri Dec 29, 2006 6:20 pm
----
It does automatically (after you click what you have to click), I do not use that software so I might not be the right person to help you, but as far i know it does a great job converting even huge databases.

#18: Re: u8tf Encoding Problem After upgrade Author: Phoenix, Location: Netizen

Posted: Fri Dec 29, 2006 7:48 pm
----
I use it and can confirm - UltraEdit is very very good, and does extremely large files very quickly Very Happy

#19: Re: u8tf Encoding Problem After upgrade Author: PartyMarty,

Posted: Fri Dec 29, 2006 11:17 pm
----
Ok great but can somebody please tell me what I have to do?

#20: Re: u8tf Encoding Problem After upgrade Author: sarah,

Posted: Sat Dec 30, 2006 12:24 am
----
I don't know how to do it with UltraEdit either. I must have done it the hard way, which is as you described above. Find a messed up character, see what it is in the data, replace with the UTF8 appropriate character. Rinse, lather, repeat. I also did it all in phpMyAdmin because my posts text table is big.

#21: Re: u8tf Encoding Problem After upgrade Author: PartyMarty,

Posted: Sat Dec 30, 2006 12:29 am
----
Ya thats what it is looking like on this end to! Can't say I am looking forward to it!

#22: DB Character Set Conversion Woes Author: Pazu,

Posted: Thu Feb 01, 2007 1:43 pm
----
I’m trying to convert a DB to UTF-8. The problem is there are two “encoding” to address in the DB. After reading a couple of Wiki articles here I’m still stumped.

History: the DB was originally started under PHP-Nuke, then migrated to CPG-Nuke, then migrated to Dragonfly.

I’ll describe one example character, the right-single-quote character ’ (Unicode:0093 UTF:C293).

(I tried to paste some of the raw characters here, but they showed up as �. See the attached text file.)

So, the first sequence successfully converts, but the second and third obviously do not.

Is there any hope of normalizing the character set of this misbegotten DB into sane UTF-8?

#23: Re: DB Character Set Conversion Woes Author: Pazu,

Posted: Thu Feb 01, 2007 1:48 pm
----
Hm, the text file didn’t attach. Let’s try that again.

#24: Re: DB Character Set Conversion Woes Author: Pazu,

Posted: Thu Feb 01, 2007 1:49 pm
----
(FYI, I’m working with PartyMarty on his previously-posted-about DB issues.)

#25: Re: u8tf Encoding Problem After upgrade Author: GalloiseBlonde, Location: France

Posted: Tue Aug 21, 2007 11:38 pm
----
I had this exact same problem upgrading from whatever it says below in my profile to 9.1.2.1 and changing utf8 to NULL in the config.php as suggested in this thread fixed it. Thanks for your help.

-> Add-Ons & Blocks

All times are GMT

Go to page Previous 1, 2 :| |: Page 2 of 2