[wp-hackers] The \ problem in posts

[Luc Saint-Elie]

Florian

Do you know if this operation is safe for a non English database.

PhpMyAdminb handles UTF-8 in a rather strange way.

I'm French, a typical database entry looks this way :

http://blog.saint-elie.com/wp-content/phpwp.jpg

Luc

At 11:34 +0200 28/06/04, Zarniwoop wrote:
>I had the same problem but for the curious there's a simpler solution
>than hand-editing all your posts. Please have a look at phpmyadmin if
>it supports all the mentioned steps (newer version do).
>
>0. Make a complete backup of your database before you go on.
>1. Take phpmyadmin and export the posts table (wp_posts) as SQL.
>2. Make a backup of this file, if anything goes wrong.
>3. Open the file with your preferred text editor and do some search 
>and replace.
>    Replace `\\\'` with `\'` (single quotes)
>    Replace `\\\"` with `\"` (double quotes)
>    Replace `\\\` with `\` (backslashes)
>    Take care when there are lots of backslashes and eventually correct
>them later when
>    you're back in WP.
>4. Back to phpmyadmin, delete the posts table.
>5. Select the database (not a single table) and go to the tab called
>"SQL". There should
>    be a button called "Browse..." where you can select the modified
>file. When you click
>    on "Ok" it will create the posts table and import all the changes
>you've made.
>6. Have a look at the posts if all has gone right. (Titles would need
>some changes also).

-- 
Luc Saint-Elie  Journaliste
7, rue Androuet
75018 Paris
Mail: luc at saint-elie.com
Tel : 08 70 73 20 28
Mob : 06 12 90 19 65
http://blog.saint-elie.com