Copied the following from the Moving WordPress Tutorial (near the top, steps 2 -3):
Using WORDPAD or another plaintext editor, open the .sql database file.
If you use Word, or any sort of word-processor, or certain html editors, you WILL cause errors.
Is it true that plaintext editors can display accents and other similar formatting? WordPad does show these with the content in my .sql file.
Elsewhere it was mentioned to use only Save, not Save As. However I wonder if this good advice as room for non-compliance. Apparently my .sql file has encoding differences when restored to its new home with default UTF-8 settings. I don’t know what the previous install was set to if not to the WP standard UTF-8 encoding there, but there are many character errors now.
WordPad has a Unicode format option, but this would be a use of Save As. Also, the Unicode there is UTF-16. Is there a reason the file couldn’t be opened in Word as text only, then saved to UTF-8 there?
- The topic ‘moving wp tutorial and text encoding’ is closed to new replies.