omnetelecom
(omnetelecom omne)
August 10, 2020, 5:48pm
#1
good afternoon, I’m using extension, mysql-database with kodula, but the query is showing this, even though I already put the command $ conn = new mysqli ($ DB_ADDRESS, $ DB_USER, $ DB_PASS, $ DB_NAME);
mysqli_set_charset ($ conn, “utf8mb4”); // connect
in mysql.php it still shows up, you need to do something in php.ini or apache.
I thank everyone
1 Like
Rogerio_Rios
(Professional Support)
August 10, 2020, 5:54pm
#2
ALTER DATABASE YourDataBase
CHARSET = Latin1 COLLATE = latin1_swedish_ci;
or
UTF8 - utf8_general_ci.
Oh…Deep Host Extension ?
You need change charset and collation.
The collate utf8mb4 is utf8mb4_general_ci
omnetelecom
(omnetelecom omne)
August 10, 2020, 6:20pm
#3
ALTER DATABASE mkradius CHARACTER SET utf8 COLLATE utf8_unicode_ci;
I did it like that and even so it continues with the characters
Rogerio_Rios
(Professional Support)
August 10, 2020, 6:22pm
#4
Did you try with = ( equal sign ) ?
Rogerio_Rios
(Professional Support)
August 10, 2020, 6:36pm
#5
Try alter your table or column :
ALTER Table YourTableName Modify YourColumnName FieldType(LenghtField) Character Set utf8 COLLATE utf8_unicode_ci
ALTER TABLE YourTableName Convert To Character SET utf8 COLLATE utf8_unicode_ci
And your Database :
ALTER Database YourDataBaseName Convert To CHARACTER SET utf8 COLLATE utf8_unicode_ci
And in the create table put at the end after closing the parenthesis ENGINE = InnoDB DEFAULT CHARSET = utf8;
In PHP script…header(‘Content-type: text/html; charset=UTF-8’);
Open your script and save with encoding UTF-8 without BOM (NOTEPAD ou SUBLIME )
omnetelecom
(omnetelecom omne)
August 10, 2020, 6:47pm
#6
must be inserted in mysql.php
1 Like
Rogerio_Rios
(Professional Support)
August 10, 2020, 6:54pm
#7
Did you read the topic I showed above?
There it was resolved…
At the top of the script before any echo or print…
Rogerio_Rios
(Professional Support)
August 10, 2020, 8:16pm
#8
Do not forget to check Resolved in the possible answer that was the solution.
Rogerio_Rios
(Professional Support)
August 13, 2020, 2:26am
#9
Solved? Can you post to community users?
vknow360
(Sunny Gupta)
August 13, 2020, 3:56am
#10
Wait…what? Extension?
If you are talking about Deep Host’s extension then your topic is going to be closed soon as we don’t support his extensions.
1 Like
Boban
(Boban Stojmenovic)
August 13, 2020, 8:07am
#11
As mentioned above, we no longer allow questions about the use of extensions from Deephost since he neither help/support them…
1 Like