News:

SMF 2.1.6 has been released! Take it for a spin! Read more.

Main Menu

problem with converting database char UTF8

Started by denislici, August 27, 2006, 04:30:13 PM

Previous topic - Next topic

denislici


i have upgraded my forum from rc2 to rc3 in normal language files(latin1)... but i need utf8 so i uploaded the x.x-utf8.php language files and set it from the admin panel server settings...

in forum maintenance there is a convert the database and data char to utf8 option... when i try to do this i get this error message

Quote

Duplicate entry '32' for key 1
File: c:\program files\easyphp1-8\www\rc3upgrade\Sources\Admin.php
Line: 1233



in that line there are these codes:

Quote

// Change the columns back, but with the proper character set.
         db_query("
            ALTER TABLE $table_info[Name]" . substr($updates_text, 0, -1), __FILE__, __LINE__);




plz help !!!!
Love the Creature for Creator's sake. (English)
Duje Krijesen per hire te Krijuesit. (Albanian)
Yaradılan'ı sev Yaradan'dan ötürü. (Turkish)
Ami la Creatura per ce la creato il Creatore. (Italian)

denislici


i have done something:

after upgraded in normal language files, i create the backup and restore it to a new rc3 utf8 language files forum... then i converted the database and data char to utf8 and the html codes succesfully.... but the messages and the kategories displays again wrong characters, instead of my language characters it displays ?      when i write a new message there is no problem with characters but with the previous messages there is...

what should i do ?? help plz....

Love the Creature for Creator's sake. (English)
Duje Krijesen per hire te Krijuesit. (Albanian)
Yaradılan'ı sev Yaradan'dan ötürü. (Turkish)
Ami la Creatura per ce la creato il Creatore. (Italian)

Leipe Po

do you have that charset installed in you browser?....
There is only one thing more importend to me then coding:
My Girlfriend

Microsoft - "You've got questions.  We've got dancing paperclips."

denislici

#3

  yes... it works fine with new utf8 forum... when i restore the backup the characters become strange...

  i said that when i send a new message there is no char problem but with previous messages yes
Love the Creature for Creator's sake. (English)
Duje Krijesen per hire te Krijuesit. (Albanian)
Yaradılan'ı sev Yaradan'dan ötürü. (Turkish)
Ami la Creatura per ce la creato il Creatore. (Italian)

denislici

#4

still here... anybody knows how to convert the database charset ???? plz...
Love the Creature for Creator's sake. (English)
Duje Krijesen per hire te Krijuesit. (Albanian)
Yaradılan'ı sev Yaradan'dan ötürü. (Turkish)
Ami la Creatura per ce la creato il Creatore. (Italian)

Advertisement: