Forum LAMS for Tech-Heads - General Forum: Re: Re: Re: Problems with accents and ñ

By: Jun-Dir Liew

[ Reply | Forward ]

I can't seem to reproduce this. Can you check the character set for your database?

mysql> select * from information_schema.schemata;

In your previous thread you mentioned:

When I edit the table with mysql, the name are show correctly, meaning that the problem occurs during saving at page level.

But this doesn't necessarily confirm that the database is in utf8 since some of the non-english characters are part of other charsets anyway.

Posted by Jun-Dir Liew

By: Miguel Muñoz

[ Reply | Forward ]

For lams2 the  DEFAULT_CHARACTER_SET_NAME is utf8 and the  DEFAULT_COLLATION_NAME is utf8_general_ci.

I found that as default, my wildfire database is latin, but I'm not using the chat.

You can find the complete output attached as a text file.

Posted by Miguel Muñoz

By: Miguel Muñoz

[ Reply | Forward ]

I think I didn't explain well.

When I create a sequence and I save it with a name as for example "Introducción", in the table 'lams_learning_design' i see "Introducción", then I add this sequence to a class and then I see "Introdu??ion" in the table 'lams_lesson'.

When I said save level I mean lesson creation level.

Posted by Miguel Muñoz

By: Jun-Dir Liew

[ Reply | Forward ]

Thanks for the clarification, but it's still the same - I can't reproduce the problem.

Have you tried this on demo.lamscommunity.org? Ideally from the same machine.

Posted by Jun-Dir Liew