Jump to content

Back Office Save Product Corrupts Language/Character Encodings


Recommended Posts

In my DB (encoded in UTF-8) I have the correct translations for a product.

But when I make a save for the product in the back office the translations are corrupted.

Any ideas why this is happening? Currently on v.1.4.8.2.

Thanks for any suggestions,

Ian

 

e.g. VIETNAMESE

 

DB Contents product field Description Short

<p> hẹp satin aliceband fascinator với lưới lớn vải hoa với lông. màu tím, hồng, xám, xanh ngọc, đen hoặc kem </p><p> phổ biến tại các đám cưới và các chủng tộc </p>

 

BACK OFFICE (OLD SCHOOL THEME) PAGE SOURCE EXTRACT

 

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">   <head>   <meta http-equiv="Content-Type" content="application/xhtml+xml; charset=utf-8" />   <meta name="robots" content="NOFOLLOW, NOINDEX" />     <textarea class="rte" cols="100" rows="10" id="description_short_20" name="description_short_20"><p> hẹp satin aliceband fascinator với lưới lớn vải hoa với lông. màu tím, hồng, xám, xanh ngọc, đen hoặc kem </p><p> phổ biến tại các đám cưới và các chủng tộc </p></textarea>    

BACK OFFICE DISPLAY IN DESCRIPTION SHORT TEXT AREA

 

hẹp satin aliceband fascinator với lưới lớn vải hoa với lông. màu tím, hồng, xám, xanh ngọc, đen hoặc kem

phổ biến tại các đám cưới và các chủng tộc

AFTER CLICKING SAVE

BACK OFFICE DISPLAY IN DESCRIPTION SHORT TEXT AREA

hẹp satin aliceband fascinator vá»i lÆ°á»i lá»n vải hoa vá»i lông. màu tím, há»ng, xám, xanh ngá»c, Äen hoặc kem

phá» biến tại các Äám cÆ°á»i và các chủng tá»c

 

Link to comment
Share on other sites

On further inspection hitting the save button once does not update the product_lang table as it usually hits a field too long error. It seems maybe htmlentities is corrupting the translations?

Anyone seen this problem before?

I cannot find a solution.

db/my.conf and php.ini seem to be very well utf-8 configured.

Cannot find the answer!

Hope someone can help thanks.

Link to comment
Share on other sites

This was a problem in the php.ini file.

Strangely had too much utf-8 encoding setup for mbstring.

Probably HTTP input encoding translation enabled  was the problem

Working settings were,

 

mbstring Multibyte Support enabled Multibyte string engine libmbfl HTTP input encoding translation disabled libmbfl version 1.3.2

 

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

 

Multibyte (japanese) regex support enabled Multibyte regex (oniguruma) version 5.9.1

 

Directive Local Value Master Value mbstring.detect_order no value no value mbstring.encoding_translation Off Off mbstring.func_overload 0 0 mbstring.http_input pass pass mbstring.http_output pass pass mbstring.http_output_conv_mimetypes ^(text/|application/xhtml\+xml) ^(text/|application/xhtml\+xml) mbstring.internal_encoding no value no value mbstring.language neutral neutral mbstring.strict_detection Off Off mbstring.substitute_character no value no value
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...