Ticket #2942 (closed defect: fixed)

Opened 2 years ago

Last modified 1 year ago

Database tweaking and ".thumbnail" translation problems

Reported by: vizualbod Assigned to: anonymous
Priority: normal Milestone: 2.2
Component: General Version: 2.0.3
Severity: minor Keywords: utf8, latin1, database, thumbnail, translation, multilingual
Cc: public@jimisola.com

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.

Change History

07/13/06 16:27:18 changed by tenpura

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

09/21/06 01:30:44 changed by foolswisdom

  • milestone changed from 2.0.4 to 2.1.

10/11/06 21:22:22 changed by jimisola

  • cc set to public@jimisola.com.

12/01/06 03:26:59 changed by matt

  • milestone changed from 2.1 to 2.2.

03/21/07 06:07:19 changed by ryan

  • status changed from new to closed.
  • resolution set to fixed.

(In [5071]) Don't translate .thumbnail extension. fixes #2942