New answers tagged

2

Depending on what RDBMS you are using: You can try altering the Latin1-encoded column to use an encoding of UTF-8, if the RDBMS supports such an operation. If you are using MySQL, you should look at this related Question on S.O.: Converting mysql tables from latin1 to utf8 You can try: Adding a new column with an encoding of UTF-8 UPDATE new_column = ...


1

This is a rather general question so my answer will be also quite general... Consolidate everything to UTF-8! If possible reload at least the latin1 entries: This time converting latin1 to UTF-8 which should always be possible. Depending on the database product the conversion can be performed by the import tool. Starting with flat files and a custom ...


0

"displayed incorrectly" -- That does not necessarily mean that the text is stored incorrectly. How many steps do you have here? You have data in a WP database? Please provide SHOW CREATE TABLE for one of the tables so we can verify whether it is latin1 or utf8. Also, do SELECT col, HEX(col) to see what you have in the table for €. For utf8, the hex ...



Top 50 recent answers are included