Frog CMS

Hi there, I have just installed frog and let me start by saying that it looks good :)

But I do unfortunately have one major problem with it - it does not accept any of the danish characters - and since I am going to use this to create pages with danish in them, this is a show stopper.

So my question is - are you planning on adding support for encoding those special signs that are found in other languages?

The problem is easily reproduceable - simply create a page and input a non-english character in the title or the actual page. After pressing save - everything from and including the sign is removed.

Hi david,

Yes, I kinda figured it was possible somehow (given that this CMS is being developed by a french person), but I have had no luck in tracking the problem down. I need to look more into the code before I can give a definitive answer on that however.

I looked at the thread, but it did not really provide any answers to me, because I have two sites running - one with a .htaccess file and one withouth - and both have the problem. Both databases are using UTF8 (utf8_danish_ci) so I do not think that is the problem.

Thanks for the quick answer though!

Ah - the missing edit button... anyway, the important part is that both the content and content_html contains the letters æøå. But if I look into the database nothing has been updated?!

When I execute the update manually it works fine - and now the letters also show up in the page editor - but they dissapear if I save the page again.

any bright ideas of where I can debug this issue further?

Sadly that is not the case -- I tried dumping the page title before and after running ks but the string remained unaltered.

I can not get my head around why the query that mysql logs does not do anything - because to me it seems like frog passes the correct string and creates the correct query, but mysql for some reason rejects it.

This is not related to kses - I have tried both uncommenting kses (that did not change anything) and to view the output after running kses (the output stays untouched after running kses).

I have looked at the issues you linked to but have been unable to see a connection since what I am experiencing is somewhat different. All input after entering a special char (including the special char) is simply removed and I suppose this is due to some utf-8 conflict, but I have yet to identify where this error occurs.

I will look further into it today.

I finally figured out what caused the problem - php, mysql and utf8.

It seems like php is trying to send an uft8 string to mysql, but it simply ignores the special chars. So I tried to send it as latin-1 which suprisingly worked. The problem now however is that it is impossible to fetch the char from mysql again, since php now can not figure out what it has recieved.

so in order to fix this I need every update/insert to use latin-1 and every select to use utf8.

oh the joy of character encodings...