Geeklog Forums

I am from China.I find that There is a very big bug about Chinese Article on Geeklog 1.8.1 and 2.0.0rc1.
When I write a Chinese Article,my geeklog sites When I finished writing the Chinese article, and then published on my website.Articles become "????????????". I installed the website, check the "UTF-8". Partner has to try Geeklog 1.8.1 and 2.0.0rc1, re-install the site twice I found the MySQL database table article, those Chinese article is displayed as "????????????" I try to comment on the Japanese, the Japanese lettersChinese and Japanese UTF-8 language file for???????. "My Geeklog site I think it should Geeklog program. previous partners seem to install Geeklog 1.7.x, there is no suchproblems.
I hope you will be able to fix this problem is very urgent.

---

The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me

I mentioned Forum Geeklog official website, and hair stomach again the Chinese Post, is also showing a lot of "??????????????"?I come from China, I wrote in the January 8, 2013 at 21:00 of the problem posts.?

---

The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me

My personal website?http://www.chunxiao.me?owered by wordpress?
http://cn.chunxiao.me(powered by Geeklog )

I support Geeklog ?Welcome to contact me

---

The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me

Your site displays Chinese characters fine so it is probably your database.

Is your database UTF-8?

Also make sure your geeklog tables are UTF-8. I believe a bug has been reported that on some installs they are not.

Tom

---

One of the Geeklog Core Developers.

I checked my MySQL database is UTF-8, attach screenshots(http://www.chunxiao.me/xweb/image/a1.png ; http://www.chunxiao.me/xweb/image/A2.png)
I published in Geeklog.net Chinese comments, are also on display???????? "Geeklog is the official website also does not support the Chinese-language content. I recognize Geeklog program may not support the Chinese, perhaps the the Geeklog program PHP file is not strictly support UTF-8.
Could you check the recent the Geeklog program files in the new version to fix the error.

---

The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me

To convert your Geeklog to utf-8 you can find inspiration on:

- http://www.geeklog.net/article.php?story=200410120657418

- http://geeklog.fr/wiki/iso-8859-to-utf8

---

I'm available to customise your themes or plugins for your Geeklog CMS

Your right Geeklog.net doesn't support Chinese characters

We need to convert our db over.

Your database may be utf-8 but are all the tables? Make sure the tables are utf-8. If you checked the utf-8 option in the install and they still are not then you have come across a bug (which has been submitted already). You will have to manually convert the tables

On my development server the utf-8 option works for me in the install and I can save chinese characters in comments and stories.

Visit Ben's links for more information on how to do this

---

One of the Geeklog Core Developers.

Today, I view the MySQL database table, the original codes are "latin1_swedish_ci I modify Stories library table structure will change" latin1_swedish_ci "to" UTF8_general_ci, I re-published the Chinese article, this time can be displayed.
However, when I install Geeklog (installed three or four times), I remember all the UTF-8 option is checked, but still "latin1_swedish_ci" .. I think Geeklog installer appears bugs. Should be checked and corrected.

---

The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me

You are correct it is a bug. I cannot reproduce it (I am on a Windows Server) but another person reported similar problems. Can you let us know what OS you are using along with versions of your web server, php and mysql?

Thanks

Tom

---

One of the Geeklog Core Developers.

Server operating system is Linux, the system architecture is X86_64; MySQL version 5.1.66-cll; PHP version 5.2.17; the PERL version is 5.8.8; Apache version is 2.0.63
I also found that the site name and slogan can not be filled in either English or Chinese. But you can modify the database table to fill in either English or Chinese, all OK. Attach screenshots (http://www.chunxiao.me/xweb/image/geeklogbug/01.png
http://www.chunxiao.me/xweb/image/geeklogbug/02.png)
Crawls the web search engine spider simulation, Title is blank. Perhaps this is a new bug.

thanks

chunxiao.

---

The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me

This is not a bug.
Please install after setting MySQL's collation "utf8_general_ci".

Geeklog works on multi byte languages.
e.g.
http://www.jtb-gts.com (English/Chinese/Korean)
http://www.geeklog.jp (Japanese)

---

Geeklog Japan https://www.geeklog.jp

According to one of Geeklog Japanese core member, Debian default install makes MySQL's collation latin_swedish_ci. Maybe this occurs depending on server OS' distribution, version or settings etc.

Thus, in case of multi byte language environment, we need to check if MySQL's collation is utf8_general_ci before Geeklog installation. This is our Japanese community's understanding. This is not a Geeklog's bug.


Meanwhile, I am please to know Geeklog has been used for Chinese language as well.

I recently with Geeklog program, the establishment of a Geeklog Chinese lovers community site (site name Hanyu Pinyin is " Zhi Le Gong Yuan " ).
URL is http://cn.chunxiao.me . Welcome to visit!

---

The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me

I've modified by manually "professional" theme folder under "header.thtml" file, and can show the Title and slogan. Facilitate the search engines crawl and included.

---

The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me

At the very least it sounds like we should at least inform the user in the docs to make sure the collation of their database is utf-8.

---

One of the Geeklog Core Developers.

Only "utf8_general_ci"

utf8_unicode_ci ... garbled characters in part.

---

Geeklog Japan https://www.geeklog.jp

Indeed. This makes Geeklog more user friendly rather than insisting "this is not a bug". Hope this would be included in wiki.geeklog.net installation page or readme docs in the near future.

I guess this is all of Japanese CMS user's understanding.

Japanese wiki for installation:
http://wiki.geeklog.jp/index.php?title=Install14

Encode: UTF-8 Unicode (utf8)
Collation: utf8_general_ci

---

Geeklog Japan https://www.geeklog.jp

I think you said it right.Because my website host Server character set UTF-8 Unicode (utf8) ,server connection proofreading "utf8_general_ci". I put my Geeklog site database table structure was revised to "utf8_general_ci", after the test, the successful realization of the Chinese, Japanese, Vietnamese, Korean, Thai, Arabic, Farsi, and other non-Latin alphabet language support, but does not support Lao (a Southeast Asian country, which borders China); Mongolian and Tibetan are not tested.
I use Cpanel host in the United States, not on behalf of the Chinese mainland. Although I come from China mainland, but In the Internet field, the Chinese mainland is a very different very special Internet environment.

---

The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me

In the field of Internet, Our mainland China use GBK character set, the main support for Simplified Chinese; Hong Kong and Taiwan use Big5 character set, the main support for Traditional Chinese.

---

The Geeklog Chinese enthusiast community website(http://cn.chunxiao.me)
My personally official blog: http://www.chunxiao.me