For different language insert in to mysql db , how i set CHARSET and COLLATE ? - Trongate MX

Forums Home / Trongate MX / For different language insert in to mysql db , how i set CHARSET and COLLATE ?

For different language insert in to mysql db , how i set CHARSET and COLLATE ?
2 years ago

Hello DC,
good day, hope every thing is fine.
I need some help about different language insert in to mysql db. how i set CHARSET and COLLATE in database setting.
thanks for your supper cool trongate framework.

2 years ago

This is more of a database question than a Trongate one.

From memory, the Desktop app uses the above char set, please check the source code on github.

Cheers,
Si

2 years ago

Thanks for your reply, I create my database this way but when i insert or update other language in to the database. it show different character in the table. i want the exact what i insert in to the database. is there any need connection level set utf8mb4
the html view is fine.

2 years ago

Dear DC,
I change the model.php and set this line and it work fine. i think you never mind to change the original code.
thanks.

Compose Reply