Chronoforms seems to be setting a default collation of 'latin1_swedish_ci' to all text fields in the databases it creates.
While this isn't a problem, any idea where I can change the default to a (more international) 'utf8_general_ci'. Would save a lot of fiddling!
Hi Nick,
I don't think ChronoForms sets it at all - try the default setting for the Joomla! schema in your database.
If you need the ChronoForms code its around line 436 in administrator/components/com_chronoforms/admin.chronoforms.php
Bob
Quite right, thank-you.
Nick
Hi
i have the same problem
The mysql joomla DB collation is setted to "utf8_general_ci"
and all the tables (myisam and innodb) are created with utf8_general_ci,
also jos_chronoforms, jos_chronoform_actions and jos_chronoconnectivity.
But the tables created directly with chronoforms have "latin1_swedish_ci" collation.
I am not a joomla/chronoform expert, so i do not know how to check/set to avoid this.
The only thing that i can do to solve, is to run a query to change collation
from "latin1_swedish_ci" to "utf8_general_ci".
I used this query in mysql:
ALTER TABLE `jos_chronoforms_data_richiesteinfosito`
CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
there is another way to correct the collation?
thanks
Hi Claudio08,
As far as I know, ChronoForms doesn't set or change the collation. What is the default setting for the schema?
Bob
Hi [GH] 😀
phpmyadmin report "utf8_general_ci", but i am not an expert.
Hi Claudio,
Nor am I :-( Sorry, but I don't know where the Swedish collation is coming from.
Bob