[TYPO3-english] Danish characters are ok, but will not show or be saved?

[Jigal van Hemert]

Hi,

On 17/08/2015 23:26, David Lamhauge wrote:
> [img]index.php/fa/16401/0/[/img]I've just moved a domain of mine from
> one server to another, and something has gone wrong.
>
> As an example I have (in the attached file: typo3.png) shown three
> screen shots:

Attaching files to posts often goes wrong for those who read messages in 
newsgroups or on the mailing lists. So I'll go by what you wrote.

It's best to put images somewhere on the web and put a link to the image 
in your post.

> 1) is the top of the Page tree. As you see, two titles are missing.
> 2) is from the same Page tree, after I double click on the white part
> beside the page icon. It shows the title, which disappears when I press
> enter.
> 3) is the result if I log into the Mysql database, and selects the
> title. Perfect result with danish character 'ø'.
>
> I then convert the database from Latin to utf8, and the result is seen
> in attached file: typo3_2.png

I have no idea what you did to convert the database, but it is quite a 
bit of work if you do it manually. Besides, depending on various 
settings there may already be problems with double encoded data.

You can find more information and tools to convert databases and fix 
various problems at [1].

If you're already using TYPO3 6.x (I didn't mention the version) you're 
probably already in trouble as it requires a UTF-8 database.

> [img]index.php/fa/16402/0/[/img][img]index.php/fa/16402/0/[/img]
> begin 644 typo3.png
> MB5!.1PT*&@H````-24A$4@```9````$L"`8```#MM^7"````!F)+1T0`_P#_
> M`/^@O:>3````"7!(67,```L3```+$P$`FIP8````!W1)344'WP at 1%#,*^/CX
> MXP```!ET15AT0V]M;65N=`!#<F5A=&5D('=I=&@@1TE-4%>!#A<``"``241!
[...]
> M)/;0V]M[4)]$VP[YV:>OVO_*^Z_BN'Z-Y&&WU22$F;(^\Z(7)80PA!!"/R"V
> M\E^XZ:8S]XTW4?^32/B.AV#$]A/C\N#'%H5P]SY<4%6D**Y%Q+/D_P-93`0\
> 080#\Y0````!)14Y$KD)@@@``
> `
> end

(This is how the image is shown in for example Thunderbird news reader; 
a lot was cut away)

[1] 
http://www.typo3coder.nl/development/upgrade-to-typo3-62-and-database-issues/

-- 
Jigal van Hemert
TYPO3 CMS Active Contributor

TYPO3 .... inspiring people to share!
Get involved: typo3.org