|
Forums118
Topics9,194
Posts195,566
Members1,323
| |
Most Online5,850
Feb 29th, 2020
|
|
|
S |
M |
T |
W |
T |
F |
S |
|
|
1
|
2
|
3
|
4
|
5
|
6
|
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
|
14
|
15
|
16
|
17
|
18
|
19
|
20
|
|
21
|
22
|
23
|
24
|
25
|
26
|
27
|
|
28
|
29
|
30
|
|
|
|
|
|
|
Here is a link to show exactly where the Space Station is over earth right now: Click Here
|
|
|
2 registered members (ProdigalOne, 1 invisible),
2,639
guests, and 15
spiders. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
Process of Changing to UTF8
#190459
08/11/19 10:03 AM
08/11/19 10:03 AM
|
|
|
This is where we are going to discuss the process of changing to UTF8.
Anybody who knows the process of doing this safely, please share your thoughts here.
|
|
|
Re: Process of Changing to UTF8
[Re: Daryl]
#190461
08/11/19 10:18 AM
08/11/19 10:18 AM
|
SDA
Active Member 2021
5500+ Member
|
Joined: Apr 2008
Posts: 7,003
The Orient
|
|
This is where we are going to discuss the process of changing to UTF8.
Anybody who knows the process of doing this safely, please share your thoughts here. I've never worked with UBB.threads specifically before, but I have some experience with converting MySQL databases. What database and/or engine do you use with UBB.threads? Also, what character set is it currently using? Blessings, Green Cochoa.
We can receive of heaven's light only as we are willing to be emptied of self. We can discern the character of God, and accept Christ by faith, only as we consent to the bringing into captivity of every thought to the obedience of Christ. And to all who do this, the Holy Spirit is given without measure. In Christ "dwelleth all the fulness of the Godhead bodily. And ye are complete in Him." [Colossians 2:9, 10.] {GW 57.1} -- Ellen White.
|
|
|
Re: Process of Changing to UTF8
[Re: Daryl]
#190491
08/12/19 07:29 PM
08/12/19 07:29 PM
|
|
|
|
|
|
|
Re: Process of Changing to UTF8
[Re: Daryl]
#190495
08/13/19 06:13 AM
08/13/19 06:13 AM
|
SDA
Active Member 2021
5500+ Member
|
Joined: Apr 2008
Posts: 7,003
The Orient
|
|
My experience is mostly limited to MySQL and MariaDB. In MySQL, some helpful commands might include the following: To show the character set for the database, the query would be: SHOW VARIABLES LIKE "character_set_database"; To see the character collation for a particular table: SHOW FULL COLUMNS FROM table_name; For example:
mysql> show full columns from KJV;
+-----------+-------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+-----------+-------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
| RecordNum | smallint(6) | NULL | NO | PRI | NULL | | select,insert,update,references | |
| Book | tinyint(4) | NULL | NO | | NULL | | select,insert,update,references | |
| Chapter | smallint(6) | NULL | NO | | NULL | | select,insert,update,references | |
| Verse | smallint(6) | NULL | NO | | NULL | | select,insert,update,references | |
| Text | mediumtext | utf8mb4_unicode_ci | YES | | NULL | | select,insert,update,references | |
+-----------+-------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
Check if the conversion will see UTF8: SELECT CONVERT(CAST(Text as BINARY) USING utf8) FROM table LIMIT 5; Blessings, Green Cochoa.
We can receive of heaven's light only as we are willing to be emptied of self. We can discern the character of God, and accept Christ by faith, only as we consent to the bringing into captivity of every thought to the obedience of Christ. And to all who do this, the Holy Spirit is given without measure. In Christ "dwelleth all the fulness of the Godhead bodily. And ye are complete in Him." [Colossians 2:9, 10.] {GW 57.1} -- Ellen White.
|
|
|
Re: Process of Changing to UTF8
[Re: Daryl]
#190496
08/13/19 08:47 AM
08/13/19 08:47 AM
|
|
|
According to the information I have, the default is UTF-8:
default_charset UTF-8
|
|
|
Re: Process of Changing to UTF8
[Re: Daryl]
#190498
08/13/19 09:37 AM
08/13/19 09:37 AM
|
SDA
Active Member 2021
5500+ Member
|
Joined: Apr 2008
Posts: 7,003
The Orient
|
|
Then the next step is to make sure that the forum software is also UTF8. It should accept only UTF8 input from each form. This may be a forum setting somewhere in the administration panels. According to UBBWiki pages: https://www.ubbwiki.com/article/view/29/converting-to-utf8.htmlIn 2010, as part making that same forum much more SEO friendly, I updated in the language files and the header meta tags from "iso-8859-1" to "utf-8" (Control Panel > Languages > Language Editor > generic.php > CHARSET).
It looks like there may be some helpful information on that page, including advice to backup the DB before changing things! Blessings, Green Cochoa.
We can receive of heaven's light only as we are willing to be emptied of self. We can discern the character of God, and accept Christ by faith, only as we consent to the bringing into captivity of every thought to the obedience of Christ. And to all who do this, the Holy Spirit is given without measure. In Christ "dwelleth all the fulness of the Godhead bodily. And ye are complete in Him." [Colossians 2:9, 10.] {GW 57.1} -- Ellen White.
|
|
|
Re: Process of Changing to UTF8
[Re: Daryl]
#190499
08/13/19 10:48 AM
08/13/19 10:48 AM
|
|
|
The character set in that file is iso-8859-1.
If I were to simply change it to utf-8, what would happen?
|
|
|
Re: Process of Changing to UTF8
[Re: Daryl]
#190502
08/13/19 11:11 AM
08/13/19 11:11 AM
|
SDA
Active Member 2021
5500+ Member
|
Joined: Apr 2008
Posts: 7,003
The Orient
|
|
If the database is already set up to accept utf8, there's no question but that, going forward, the posts would all be handled correctly after the change. However, the old posts may first need to be converted before they will be properly displayed.
Here's the deal: Your database has been receiving ISO-8859-1 but storing it as UTF-8. This means if you convert the forum to UTF-8, it will now be receiving posts that have been stored in ISO-8859-1 while expecting UTF-8. This will likely mean that for certain characters, they will show up incorrectly.
There are websites that talk about this problem, because you are hardly the first to face it. That is where the MySQL command to convert from one character set to another may be useful. On the other hand, it may not be possible via a command like that without exporting the entire DB first and re-importing it after making an adjustment to the exported file's character set identification.
I've been through this process before, and it's not too fun, but can be done in a couple hours' time if needing to research how first--and if one were very familiar with the process already, it might be less than 20 minutes, start to finish.
You can find helpful guides for how to do it by googling for something like "convert mysql database to utf8".
Blessings,
Green Cochoa.
We can receive of heaven's light only as we are willing to be emptied of self. We can discern the character of God, and accept Christ by faith, only as we consent to the bringing into captivity of every thought to the obedience of Christ. And to all who do this, the Holy Spirit is given without measure. In Christ "dwelleth all the fulness of the Godhead bodily. And ye are complete in Him." [Colossians 2:9, 10.] {GW 57.1} -- Ellen White.
|
|
|
Re: Process of Changing to UTF8
[Re: Daryl]
#190513
08/13/19 05:51 PM
08/13/19 05:51 PM
|
|
|
I am also asking the UBB people about this in their help forum.
|
|
|
|
|
Here is the link to this week's Sabbath School Lesson Study and Discussion Material: Click Here
|
|
|
