Opened 7 years ago
Closed 6 years ago
#2942 closed defect (bug) (fixed)
Database tweaking and ".thumbnail" translation problems
| Reported by: |
|
Owned by: |
|
|---|---|---|---|
| Priority: | normal | Milestone: | 2.2 |
| Component: | General | Version: | 2.0.3 |
| Severity: | minor | Keywords: | utf8, latin1, database, thumbnail, translation, multilingual |
| Cc: | public@… |
Description
Translation of the string ".thumbnail" (part of the name of thumbnail picture) may cause problems (no thumbnails showing) when multibite character used in the translation. I spotted it in with slovak translation and database converted to UTF-8. I recommend this ".thumbnail" string not to be translatable or to filter multibite characters in the name of the thumbnail file in the process of their creation.
Database in latin1 cause problems with some characters in slovak language, so I ever have export, convert all wrong chars to UTF-8, change all strings latin1 to utf8 and ad a line
mysql_query("set names utf8",$this->dbh);
to wp-db.php on line 74 to tell my database is in uft8.
Note: See
TracTickets for help on using
tickets.
To avoid confusion, let me explain. "SET NAMES XXX" is the statement what character set the client will use to send SQL to the server and won't do anything about the database character set.
Check this out:
http://trac.wordpress.org/ticket/2828