WebsiteBaker Support (2.12.x) > General Help & Support

Strange characters after upgrade from 2.8.3 to 2.12.1

<< < (3/5) > >>

Gast:
So, i compare the original sql with my work and i think, that i replace 98% - 99% of the strange characters  like
Baterías AAA 2*1 vs Baterías AAA 2*1
Scotch Brite Paño Absorbente vs Scotch Brite Paño Absorbente

but not
TOTONICAPÁN vs TOTONICAPÁN
bacause, that is a char, that i cannot display on my local machine. In real UTF8, it must be this character -> for the lower á and Á for the upper Á, but it isn't in your SQL-File
It's very easy, if you know, what you want, but dont forget, it's a foreign language for me. If i see the content in this project, i think, guatemala is the right location, and Totonicapán is the word, what you need - but it is, what i think, not, what i know

somewhere in the top, i write a description, how i work, a list with replacements - ich have only ~90, but in utf8, it's possible to display every character from all over the world, these are not hundred's, not tousend's

Gast:

the original


my converted text


the only unconverted character (what i found to this moment) is the upper Á, but see in the source, it's a unknow sign



now say it again, that i send you the same file back.....

Gast:
theme closed for me here - if you have a problem with a private mail, send a answer as private mail!

Gast:
not closed, one more, to explain it

screenshot 1 come's from the Netbeans-Editor, one of the best editors, he work's without problems in UTF8



but i wondering about the unknown char there, so i try it with another editor, this one show the real SQL-Code - what we see in PHPmyAdmin is the translation like the output on the webpage

the same line in the code - it show's a double converted special char Á - i try to post it here -> Á -

this is not a valid char and i dont have a combination like this in my array - but it will show the effect, when you use the "wrong" editor. The language is (i think) spain and in this language, you have a lot of strong characters


two screenshots more

here the original and real SQL-Code in the converted file



and the same line in Netbeans



or from Notepad



or Notepad++



but not in a editor, that show's real SQL-Code

it is, what i write in the private mail

1# delete from the database all tables with the prefix wb_
2# import the converted file from my email as zip-file, choose UTF8 as Format in the Import-Dialog
3# search in the editor for special wrong words, like TOTONICAP (without the wrong char!!) or use the search in PHPmyAdmin
4# for the Word "TOTONICAP" i get 23 Hits, go to the beginn of the line from every hit, there you found the table (like mod_bakery_items) and the item_id or section_id.
Go to this table in phpmyadmin and this item and replace the wrong char with the real letter directly in the database. PHPmyAdmin makes the translation for you

Important!!!: dont try to replace the wrong chars directly in the sql-file, if you use the wrong editor for that, it will destroy the complete converted file

P.S.: 23 Hits in a file with 21 Million chars, i think, thats not so bad   :evil:

svsanchez:
Hello Jacobi, thanks a lot for your excellent and long reply!

I am sorry if posting this to the forum wasn't the right thing to do (I thought it made more sense to post it here so that the solution remains posted for the future, both for my reference and anyone else having the same problem).

Just one last thing I need clarification on:

ALL my tables have the wb_ prefix. Does that mean that I have to delete ALL my tables before I import the converted DB?

Thanks again!

Navigation

[0] Message Index

[#] Next page

[*] Previous page