You are not logged in.
- Topics: Active | Unanswered
Pages: 1
#1 Re: General support (1.2) » [Fixed] Need to convert a Latin1 database to UTF8. How to do ? » 2009-06-28 12:47:36
- JLavau
Done.
Just to export search_words in binary, not hexadecimal, and zipped.
Import as Latin1.
All done, now.
#2 Re: General support (1.2) » [Fixed] Need to convert a Latin1 database to UTF8. How to do ? » 2009-06-28 12:02:40
- JLavau
Thank you.
All the tables but search_words are fixed now.
Categories, forums, users, et ranks by hand pasting.
Topics by separate import, specifying "Latin1" for the format of the imported file.
Zipped posts, so on.
Only search_words firmly resists : duplicate key !
I did not know this feature of Notepad++, but here for search_words, it does not help.
#3 General support (1.2) » [Fixed] Need to convert a Latin1 database to UTF8. How to do ? » 2009-06-27 18:22:22
- JLavau
- Replies: 5
Good morning.
Club-internet has been bought by SFR, and we must transfer and convert all our personal sites.
Done for the html, but a big problem arises with the database of the FluxBB forum :
The original at http://lavaujac.club.fr/disputatio/ is encoded in Latin1.
The target at http://jacques.lavau.perso.sfr.fr/disputatio/ should be in UTF8.
The MyAdmin at the target declines the import, because of the size of the file.
BigDump does not work, too.
MySQLDumper works at last, but fails in taking the accentuated characters. The result is that any posts and topics and forums are cut at the first accentuated character.
Unusable so.
I tried a conversion through Wordpad. The file has doubled in size, but MySQLDumper fails in restore operation, does not understand a request in Unicode...
Do you know a converter that works for our SQL databases ?
Thank you for replies !
Pages: 1