I'm attempting to create a directory with CB like the one I created manually over the past few years.
www.taichicentral.com/directory
.
I have added custom fields in a new tab to the profile. I need to be able to input English and Chinese characters in the drop-down lists.
Eg.
- Anhui Province (安徽省)
or
- Chen (陈) Style Taijiquan
My problem is the database doesn't return the Chinese text. Rather it returns:
- Anhui Province (???)
or
- Chen (?) Style Taijiquan
Mysql and phpadmin are set to collate UTF8_general_ci
I suggest using language strings instead of having to deal with collation and character set problems in MYSQL. Example as follows.
Value: _UE_ANHUIPROV
Then you'd add the below define to your CB language files. Note you should be editing the English language plugin or whatever language plugin you're using. Only use the Default as a reference.
define( '_UE_ANHUIPROV', 'Anhui Province (安徽省)' );
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
To clarify:
My purpose in adding Chinese text is to enable readers in other languages to get clarification on the meaning of the English.
For instance, there are two different styles of tai chi which are spelled "Wu" in Roman text. Chinese readers will not confuse the two styles because the written characters and the intonations are different. It is easy for any non-Chinese reader to confuse the two styles as there is no easy way to differentiate them without adding a longer explanation.
eg.
"Wu (second tone) Style (created by Wu Jiangquan)"
and
"Wu (third tone) style (created by Wu Yuxiang)"
By writing:
"Wu (吳) style"
and
"Wu (武) style"
it clarifies the meaning for readers of all languages.
I can do this easily here in this forum. I want to be able to do this in Joomla CB fields as well.
As explained you need to use language strings or you're going to have to work with your database for it to handle those strings. Please review my previous reply.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
krileon
