The Solution is:
every normal character stored in weird starts with &#
ends with ;
like this ٪
So you can simply
1-open you dreamweaver
2- new HTML file
3- code tab
4- delete all the code in it
5- put one weird code like this ٪
6- design tab
7- you can see the original character here
8- execute this sql query in PHPMyAdmin
:
update en_posts set post_title = replace(post_title, 'one weird chracter code', 'original character');
9- repeat this method for every character
10- save your sql queries in txt file
11- execute all this queries every few days
The benefits of this cleaning method:
1- for big wordpress installation this will decrease your database size & speed up your site performance
2- if you using getposts
or wp query posts
to execute posts by s=keyword
all the weird posts will not shows in your query
this is very fine at least for me
Related Posts:
- WordPress page title repeated in SOME pages
- Uppercase to sentence case for post titles
- Transient feeds and caching error
- How to get a list of articles related to a particular category from my other WordPress website?
- What is this JavaScript “require”?
- Using wpdb to connect to a separate database
- How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
- get_results using wpdb
- How can I make a WordPress database portable and url independent?
- wpdb->insert multiple record at once
- How to migrate a HTTPS WordPress installation to localhost?
- How to stop WordPress using utf8mb4_unicode_520_ci collation?
- How to monitor server for error establishing a database connection
- Exporting revisions
- WP_Options ID high
- Default WordPress settings API data sanitization
- Fatal error: Call to undefined function dbDelta()
- Connect to remote database using Localhost install
- remove missing image attachments
- Transient RSS feeds in wp_options not removed automatically?
- Best way to move live site local
- The revisions table in my database is at 70% capacity and growing. What should I do?
- How to ensure data consistency in WordPress
- Database location in WordPress
- WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
- How to display data from custom table in wordpress database?
- How to intercept update_option() before it saves data?
- Change SQL get_results to search for posts with custom term in custom taxonomy
- wpdb query on custom table not working [closed]
- How to diagnose and keep in check encoding issues?
- Add search Value to wp_list_table pagination
- stdObject stored in database. How does one convert it to usable format?
- I have a table I created, how do I make a form for a user to filter the data?
- Set Display Name to first and last name (phpmyadmin SQL Query)
- How to fix unchanged URLs in Database after running serialized search and replace script?
- wp_redirection_404 table has grown to 7GB
- Does WordPress ever need multiple databases?
- WordPress database error – Error in SQL syntax – I can’t identify any error?
- Multiple wp_options tables to share content across installs
- Merging two wp_posts tables while avoiding duplicates
- Merging two databases without borking it
- Is there a smart way to obtain a list of only some selected user meta data?
- Why does importing copies of the database dump and the document root make WordPress data inconsistent?
- Permit Login if table row exists
- How Yoast SEO plugin works with variable %%name%%?
- What would Repair and Optimize WordPress Database do?
- Move out of sync posts from one database to another
- MS Access to manage WordPress Database
- Saving zero as meta value
- Query multiple tables at once?
- Custom WordPress Table wpdb
- $wpdb->get_results($wpdb->prepare(… You have an error in your SQL syntax;
- Transferring/Uploading Data from DB to WordPress
- Can local WordPress installs share /wp-content/ folder and database?
- how to encyrpt DB_PASSWORD in wp-config
- Choosing http or https during manual installation of WordPress and database
- Stringing together content from different databases
- Delete all posts that do NOT have a specific tag
- Changing order of db results when encoding to JSON
- How to transfer from localHost to live but use the already existing database on the server?
- Safely store code(html/js..) into database
- Why does wp_links still exist in the db schema?
- can’t upgrade wordpress or install plugins, it seems to “think” it’s still on a local installation
- How not to display ALL items of a database
- How to get the records from start with A to G in php and mysql
- Link multiple user databases together?
- I wanted to Know that how can I give ingore to 0000-00-00 in my config file
- Set a cron job to delete a specific database table table every midnight
- Two separate wordpress installations at one domain
- Is there any defects for using same database prefix in WordPress for multiple sites?
- Can we store password in without being hashing?
- How to import products in host instead of database on wordpress?
- I would like some help wth an SQL query to link posts with categories
- Error establishing a database connection in wordpress
- Where is the HTML-handler part in the wpdb class?
- Want to update value in database. But it says update() on null
- Counting user’s comments – efficient way?
- Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
- The MySQL Connection could not be established., before it was joomla but i have change it into worpress
- Both VPS and domain changed but Database URL stayed the same and PHPmyadmin inaccessible to change it
- Backup Restore turns carriage returns to literal strings
- Filtering data and saving query results
- Find/ascertain latest wordpress db from multiple database copies
- Local Content different from Remote Content
- Check if a database is well installed
- Transforming an wp_options database array into a javascript obect?
- Selecting NULL value from the database
- save content in to wordpress wp_post table of database
- WordPress + Postgresql
- Database connection close
- WordPress Database Charset/Collate
- Where To Find bb_profile_data(); In bbPress?
- DB access blocked when initializing WP externally
- Saving data to database and exporting to excel
- Site does not work right, pages not showing up, even for root admin
- One information repeated on multiple locations on one site [closed]
- WordPress: Interact with Database Query Data and Login
- Showing Error(TAble already exist)
- Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
- Cant Connect to Database