Need to add Chinese text to Joomla 1.7 website, won't accept it

Hi, I'm building a website for someone that lives in China.  I don't speak Chinese though, but it should not effect the project as they have translated everything I will need.  I installed the language packs and all is well on the module part however, when I try to copy/paste the Chinese into a new document it only shows a bunch of ????????? and none of the text. I tried switching editors to use JCK Editor and setting it to not use any editor but the same result occurs.   Has anyone found a fix for this?  Is there another editor that would work with Chinese?
Webman04Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Andrew DerseIT ManagerCommented:
Can you post a file with the chinese characters in it so I can test this?  Thanks.
0
Webman04Author Commented:
Hi, OK I uploaded some of the content so you can test it.  Thanks
chinese.txt
0
Andrew DerseIT ManagerCommented:
Thank you.  I will get back to you on this.
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Andrew DerseIT ManagerCommented:
Ok, I have tested this and here's what I got.

1.PNG
0
Andrew DerseIT ManagerCommented:
Didn't mean to send that so fast...

Anyway, here's the settings I had in order to get this in there:

Global Configuration text editor: Editor- TinyMCE

I just pasted the text in there and it worked for me.  

So, my next questions are: what kind of module are you creating a customHTML?  
Have you tried to use the default TinyMCE editor?
Have you tried to turn of the text-filtering on the articles?

Here's how to do that:

Go to "Article Manager"
Go to "Options"
Go to "Text Filters"
Assuming you are a Super User change Super User "Filter Type" to "No Filtering"

Let me know if any of that helps.
0
Webman04Author Commented:
Hi, yes to all your questions and no it did not work sorry.  I have the filtering set and the TinyMCE as the editor but when I paste the chinese charactors into the editor and save it, it looks like this:

??????????????????????????????BioScience Writers?BSW???????????????????????????????????????????????530?????????????????????????????????????Nature?SCI?????????????????? ?BSW?????????????????????????????
0
Andrew DerseIT ManagerCommented:
Ok, did you try changing the text-filtering to "NO Filtering"?  

Also, do you have a test website to try this out on?
0
Webman04Author Commented:
Hi, yes I changed the setting for super admin to "No Filtering" and still won't accept the content.  I do have a test site but I can't give access to it directly as there is a lot of work on it and the client would also not like it.
0
Andrew DerseIT ManagerCommented:
No, I wouldn't need direct access to it, but I was thinking you could test the code on that site and see if it was related with the language packs you installed.

Normally this should work straight out of the box, if something was added to your site, then that would be the problem...so it might be the language pack plug-in...
0
Webman04Author Commented:
How much would you charge to fix it for me?
0
Andrew DerseIT ManagerCommented:
First, I would just look at it...no charge for looking...I could then tell you what I think it is...

Is this site live?
0
Webman04Author Commented:
It's not live but there has been a lot of other stuff done to it, it's been backup though  with Akeeba.
0
Andrew DerseIT ManagerCommented:
Oh, awesome, could you post the backup file here...if it will let you?  Then I can test it on my side and let you know what I think it is.
0
Ray PaseurCommented:
The text is fine.  But there is a character-encoding issue.  See the article here:
http://www.joelonsoftware.com/articles/Unicode.html

This shows that the text is fine:
http://www.laprbass.com/RAY_temp_chinese.php

However if you store or transmit the string in a Western encoding, you should expect a lot of question marks ;-)
<?php // RAY_temp_chinese.php
error_reporting(E_ALL);

$url = 'http://filedb.experts-exchange.com/incoming/2011/10_w41/509416/chinese.txt';
$str = file_get_contents($url);
echo $str;

Open in new window

0
Webman04Author Commented:
Hi Nukit, sorry for my delayed response, I have a bad cold.  If you can give me your email address I will send the Akeeba Backup file to you so you can have a look.  
0
Andrew DerseIT ManagerCommented:
Sure, check out my profile page...it's on there...
0
Webman04Author Commented:
Hi, I can see your website address but no email?  
0
Andrew DerseIT ManagerCommented:
Try it again...sorry...
0
Andrew DerseIT ManagerCommented:
dersecomputers ...at...gmail...com
0
Andrew DerseIT ManagerCommented:
You have to click on the Hire Me button in order to see it ;)
0
Webman04Author Commented:
Hi Nukit, I just emailed you all the info you will need.  Thanks very much for your help on this.
0
Andrew DerseIT ManagerCommented:
OK, I'll look for the email.
0
Webman04Author Commented:
Hi, I was able to fix it by changing the content table collation to UTF-8, several tables actually.  Just so you experts know this for your next questions.

Thanks
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Webman04Author Commented:
As I was the only one to fix this I gave myself the points :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Joomla

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.