• Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space

[Suggestion] UTF-8 better than latin1_swedish_ci

Status
Not open for further replies.
Ishar

Ishar

Chevereto Member
Hi everyone,

Maybe a lot of users won't understand the necessity and why the charset is so important but unfortunately, a lot of languages use accent (like é or ï and ù...)

I don't think this is important for CHV database (even if I think it would be better) but for AUS it's more important, for the news form for exemple.

So, first, is it possible to upgrade the charset to a UTF-8 without any issues (I mean for both CHV and AUS) ?

And for future version, what about using a UTF-8 standard for the database and all the mods ?
 
Chevereto uses the default db charset which is "utf8_general_ci". If your system uses another one is because either you change it or the wise guys in your server set other charset as the default. About AUS, Lautaro speaks spanish so he understand what you are talking about.
 
So, I'm sorry, but as the database is automatically created when using the script for the first time, it sets me all the tables in latin_swedish_ci

But it's a good news, I will change it for utf8_general_ci 😉


Edit :

ALTER DATABASE yourbase CHARACTER SET UTF8 COLLATE utf8_general_ci


And the problem is solved 😉
 
By default mysql uses uft8_general_ci, if the system uses another one is because someone set latin_swedish_ci as the default. Glad to know that you worked out 😉
 
By the way, I will fix the tables to force the utf8_general_ci collation in 2.4 😉
 
Status
Not open for further replies.
Back
Top