WordPress.org

Make WordPress Core

Opened 13 years ago

Closed 13 years ago

#2942 closed defect (bug) (fixed)

Database tweaking and ".thumbnail" translation problems

Reported by: vizualbod Owned by:
Milestone: 2.2 Priority: normal
Severity: minor Version: 2.0.3
Component: General Keywords: utf8, latin1, database, thumbnail, translation, multilingual
Focuses: Cc:
PR Number:

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 (5)

#1 @tenpura
13 years ago

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

#2 @foolswisdom
13 years ago

  • Milestone changed from 2.0.4 to 2.1

#3 @jimisola
13 years ago

  • Cc public@… added

#4 @matt
13 years ago

  • Milestone changed from 2.1 to 2.2

#5 @ryan
13 years ago

  • Resolution set to fixed
  • Status changed from new to closed

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

Note: See TracTickets for help on using tickets.