Make WordPress Core

Opened 18 years ago

Closed 17 years ago

#2942 closed defect (bug) (fixed)

Database tweaking and ".thumbnail" translation problems

Reported by: vizualbod's profile 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:

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
18 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
18 years ago

  • Milestone changed from 2.0.4 to 2.1

#3 @jimisola
17 years ago

  • Cc public@… added

#4 @matt
17 years ago

  • Milestone changed from 2.1 to 2.2

#5 @ryan
17 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.