| Author |
Message |
PartyMarty
Joined: Apr 24, 2005
Posts: 156
|
 Post subject: Re: u8tf Encoding Problem After upgrade
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?
PartyMarty's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Windows_NT/Apache/1.3.33 (Win32) PHP/4.3.10/4.1.9-max/4.3.10/9.0.4.0 |
|
| Back to top |
|
 |
NanoCaiordo
Joined: Jun 29, 2004
Posts: 3678
Location: Melbourne, AU
|
Post subject: Re: u8tf Encoding Problem After upgrade
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.
_________________
.:: I met php the 03 December 2003 :: Unforgettable day! ::.
NanoCaiordo's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
MySQL 5.1 / PHP 5.3 / NextGen() |
|
| Back to top |
|
|
Phoenix
Joined: Apr 19, 2004
Posts: 8729
Location: Netizen
|
Post subject: Re: u8tf Encoding Problem After upgrade
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 
_________________
• DonationsPro for DragonflyCMS, SMF, MyBB, vBulletin •
Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
 |
|
| Back to top |
|
|
PartyMarty
Joined: Apr 24, 2005
Posts: 156
|
Post subject: Re: u8tf Encoding Problem After upgrade
Posted: Fri Dec 29, 2006 11:17 pm |
|
Ok great but can somebody please tell me what I have to do?
PartyMarty's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Windows_NT/Apache/1.3.33 (Win32) PHP/4.3.10/4.1.9-max/4.3.10/9.0.4.0 |
|
| Back to top |
|
|
sarah
Joined: Mar 25, 2005
Posts: 2131
|
Post subject: Re: u8tf Encoding Problem After upgrade
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.
_________________
Diagon Alley - Top Design
sarah's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/1.3.37/4.1.21-standard/4.4.4/9.1.1 |
|
| Back to top |
|
|
PartyMarty
Joined: Apr 24, 2005
Posts: 156
|
Post subject: Re: u8tf Encoding Problem After upgrade
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!
PartyMarty's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Windows_NT/Apache/1.3.33 (Win32) PHP/4.3.10/4.1.9-max/4.3.10/9.0.4.0 |
|
| Back to top |
|
|
Pazu
Joined: Feb 14, 2005
Posts: 86
|
Post subject: DB Character Set Conversion Woes
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?
Pazu's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux 2.6.17.11-grsechg / Apache 1.3.37 / MySQL 4.1.21-standard / PHP 5.2.1 / Dragonfly 9.1.1 |
|
| Back to top |
|
|
Pazu
Joined: Feb 14, 2005
Posts: 86
|
Post subject: Re: DB Character Set Conversion Woes
Posted: Thu Feb 01, 2007 1:48 pm |
|
Hm, the text file didn’t attach. Let’s try that again.
Pazu's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux 2.6.17.11-grsechg / Apache 1.3.37 / MySQL 4.1.21-standard / PHP 5.2.1 / Dragonfly 9.1.1 |
|
| Back to top |
|
|
Pazu
Joined: Feb 14, 2005
Posts: 86
|
Post subject: Re: DB Character Set Conversion Woes
Posted: Thu Feb 01, 2007 1:49 pm |
|
(FYI, I’m working with PartyMarty on his previously-posted-about DB issues.)
Pazu's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux 2.6.17.11-grsechg / Apache 1.3.37 / MySQL 4.1.21-standard / PHP 5.2.1 / Dragonfly 9.1.1 |
|
| Back to top |
|
|
GalloiseBlonde
Joined: Jan 12, 2006
Posts: 31
Location: France
|
Post subject: Re: u8tf Encoding Problem After upgrade
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.
GalloiseBlonde's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux 2.6.9-11.ELsmp/Apache 1.3.36 (Unix)/MySQL 4.0.27-standard-log/PHP4.4.2/Dragonfly 9.0.6.1 |
|
| Back to top |
|
|
Forum FAQ
Search
Log in to check your private messages
Login
