close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

IE 9 and Chinese Characters

Thread began 4/04/2012 7:48 am by Brett Atkin | Last modified 4/10/2015 3:08 pm by Ray Borduin | 3019 views | 9 replies |

Brett Atkin

IE 9 and Chinese Characters

Recently upgraded to version 3.0.

When client enters Chinese characters in editor (and other fields) and saves the page using IE 9, submitting the form (saves to MySQL db) saves garbage text for all fields.

Works fine on Mac FF and Windows FF (what we've tested so far), but IE 9 breaks it. Everything appears correct in the editor until the record is saved and viewed again.

Is the some issue with CK Editor, IE9 and Chinese characters?

Thanks

Brett

Sign in to reply to this post

Brett Atkin

I just test in IE 8 and had the same issue.

Sign in to reply to this post

Jason ByrnesWebAssist

in your page, you should have a meta tag to set the character set used by the browser, ussually for chinese you would us the big5 character set:

<meta http-equiv="Content-Type" content="text/html; charset=Big5" />




you may also need to edit your database connection to use the Chinese character set. in the connection file, find the following line:

php:
$connectionName = mysql_pconnect($hostname_connectionName, $username_connectionName, $password_connectionName) or trigger_error(mysql_error(),E_USER_ERROR);



where connectionName is the name of the connection, and change it to:

php:
$connectionName = mysql_pconnect($hostname_connectionName, $username_connectionName, $password_connectionName) or trigger_error(mysql_error(),E_USER_ERROR);

mysql_set_charset('big5',$connectionName);
Sign in to reply to this post

Brett Atkin

Jason,

Thanks for the quick response.

We've always used UTF-8 and didn't have an issue until we updated from the previous version of HTML Editor (version using FCK Editor). Is this Big5 something specific to CK Editor and IE?

Brett

Sign in to reply to this post

Jason ByrnesWebAssist

no, it is specific to the chinese character set.

the utf-8 character set does not contain all of the characters in the chinese language.

Sign in to reply to this post

Brett Atkin

Any ideas why we're now getting these errors and why we only see them with IE. Your solution suggests we should be having a problem regardless of the browser.

Thanks

Brett

Sign in to reply to this post

Jason ByrnesWebAssist

yes, you should be having this problem in all browsers, character set is not specific to the browser, it's specific to the page.


I just tried testing this using HTML Editor 3 and cannot reproduce the problem using IE 9. I will have to look into this problem with you further to determine the cause.

Sign in to reply to this post

Stuward

Jason, I have the same issue with a bilangual website: English and Chinese. I looked at your solution, but I use one database for both English and Chinese. How can I solve this?

Sign in to reply to this post

Ray BorduinWebAssist

If you set your charset encoding to utf-8 it will work with both english and chinese. The fact that it comes from a database won't matter.

Sign in to reply to this post

Stuward

Ok, thanks Ray

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...