tag:help-archives.hannonhill.com,2010-02-09:/discussions/bug-reports/2593-en-dash-removedhidden-from-custom-metadata-fieldCascade CMS: Discussion 2015-08-14T15:46:23Ztag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-04-29T19:08:14Z2015-04-29T19:08:14ZEn dash removed/hidden from custom metadata field<div><p>Hi Sarah,</p>
<p>I was not able to reproduce the behavior you described in my
local 7.10.2 and 7.12.5 instances. See attached screenshot for
reference.</p>
<p>Curious, are you seeing this behavior in all browsers? Also, can
you confirm what collation and encoding you are using on your
database?</p>
<p>Please let me know if you have any questions.</p>
<p>Thanks!</p></div>Ryan Griffithtag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-04-29T19:12:46Z2015-04-29T19:12:46ZEn dash removed/hidden from custom metadata field<div><p>Hi Ryan,</p>
<p>This is happening in PC Chrome, PC Firefox, and Mac Chrome or
Safari. I'll have to find out about the collation and encoding, but
I'm guessing that may be the issue if you can't reproduce it.</p>
<p>Incidentally, what collation and encoding are you using on your
instances? If ours turns out to be different, I guess we should
change it?</p>
<p>Thanks,<br>
Sarah</p></div>Sarah Johnson Litag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-04-29T19:23:01Z2015-04-29T19:23:01ZEn dash removed/hidden from custom metadata field<div><p>Thank you for following up, Sarah.</p>
<p>My local instances are running on MySQL with a default character
set of <code>utf8</code> and collation of
<code>ut8_unicode_ci</code>.</p>
<p>Please keep me posted on your findings and let me know if you
have any questions.</p>
<p>Thanks!</p></div>Ryan Griffithtag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-05-01T17:31:46Z2015-05-01T17:31:46ZEn dash removed/hidden from custom metadata field<div><p>I was told BINARY collation and the UTF-9 Unicode</p>
<p>Thanks,</p>
<p>Sarah Johnson Li<br>
Web Developer | Rollins College</p></div>Sarah Johnson Litag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-05-04T19:08:14Z2015-05-04T19:08:14ZEn dash removed/hidden from custom metadata field<div><p>Hi Sarah,</p>
<p>Those settings could very well be contributing to the behavior
you are encountering. Our recommended character set and collation
settings would be <a href="http://help.hannonhill.com/discussions/bug-reports/2593-en-dash-removedhidden-from-custom-metadata-field#comment_36712033">
the ones I listed previously</a>.</p>
<p>If you have a test instance, I would suggest trying to adjusting
the database settings to see if this resolves the behavior.</p>
<p>Please let me know if you have any questions.</p>
<p>Thanks!</p></div>Ryan Griffithtag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-05-04T19:23:20Z2015-05-04T19:23:20ZEn dash removed/hidden from custom metadata field<div><p>Thanks Ryan! I'll ask our sysadmins to update the test instance
and we'll see if that fixes the problem :)</p>
<p>Sarah</p></div>Sarah Johnson Litag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-05-04T19:48:57Z2015-05-04T19:48:57ZEn dash removed/hidden from custom metadata field<div><p>Not a problem at all, Sarah. Please keep me posted on your
findings, or if you have any additional questions.</p>
<p>Have a great day!</p></div>Ryan Griffithtag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-07-23T15:22:33Z2015-07-23T15:22:33ZEn dash removed/hidden from custom metadata field<div><p>Hi Ryan,</p>
<p>Following up on this, we did change the setting in our test
instance, but page asset content has been converted to chinese
characters and the error "Content is not allowed in prolog."
appears in the view screen.</p>
<p>I guess we can't switch it successfully with existing content?
Should we try to copy over the production database and see if it
still happens?</p>
<p>Thanks,<br>
Sarah</p></div>Sarah Johnson Litag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-07-23T19:22:42Z2015-07-23T19:22:42ZEn dash removed/hidden from custom metadata field<div><p>Hi Sarah,</p>
<p>Based on your description, it sounds like there was a conversion
problem. Do you happen to know how the collation and character set
settings were changed?</p>
<p>Thanks!</p></div>Ryan Griffithtag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-07-23T19:25:45Z2015-07-23T19:25:45ZEn dash removed/hidden from custom metadata field<div><p>I honestly don't know how they changed it. I would have to ask
the sysadmin. Is there an non-ideal way to change those
settings?</p></div>Sarah Johnson Litag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-07-23T19:47:05Z2015-07-23T19:47:05ZEn dash removed/hidden from custom metadata field<div><p>Hi Sarah,</p>
<p>You should be able to use the <code>alter database</code> and
<code>alter table</code> commands. See the following for additional
information:</p>
<ul>
<li><a href="https://dev.mysql.com/doc/refman/5.0/en/charset-conversion.html">https://dev.mysql.com/doc/refman/5.0/en/charset-conversion.html</a></li>
<li><a href="http://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8">
http://stackoverflow.com/questions/6115612/how-to-convert-an-entire...</a></li>
</ul>
<p>Note: you may be running into an issue where the new character
set does not support the same characters, but let's hope that's not
the case.</p>
<p>Another possible solution could be what is <a href="http://alexking.org/blog/2008/03/06/mysql-latin1-utf8-conversion">outlined
on this page</a> where your content is already UTF8, but the
database is just incorrect. In that case you would:</p>
<ul>
<li>export the database using the current (incorrect) encoding</li>
<li>manually change the character set within the export file to the
correct one</li>
<li>drop and re-create the database using the correct encoding</li>
<li>import the updated export</li>
</ul>
<p>Please let me know if you have any questions.</p>
<p>Thanks!</p></div>Ryan Griffithtag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-07-27T20:14:21Z2015-07-27T20:14:21ZEn dash removed/hidden from custom metadata field<div><p>Thanks Ryan,</p>
<p>I'll pass this along, but IT upgraded our test instance before
trying to switch this back. This will get interesting...</p>
<p>Sarah</p></div>Sarah Johnson Litag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-07-28T11:42:54Z2015-07-28T11:42:54ZEn dash removed/hidden from custom metadata field<div><p>Hi Sarah,</p>
<p>If the encoding is still incorrect on the test instance, the
<a href="http://help.hannonhill.com/discussions/bug-reports/2593-en-dash-removedhidden-from-custom-metadata-field#comment_37464802">
steps I outlined previously</a> should still be valid.</p>
<p>To summarize, they would:</p>
<ul>
<li>Turn off Cascade on the test instance</li>
<li>Export the test database using the current encoding</li>
<li>Manually edit the export file to change the encoding
settings</li>
<li>Drop and re-create the database using the correct encoding</li>
<li>Import the export file</li>
<li>Start Cascade on the test instance</li>
</ul>
<p>Please let me know if you have any questions.</p>
<p>Thanks!</p></div>Ryan Griffithtag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-07-29T19:04:24Z2015-07-29T19:04:24ZEn dash removed/hidden from custom metadata field<div><p>Hi Ryan,</p>
<p>Just an update, our sysadmin and db admins are trying to resolve
another issue with logging in after they upgraded the test
instance. I don’t know if it has anything to do with the
character encoding change, since I was able to login before the
upgrade. Once they make progress on that, I’ll let you know
if the steps you provided resolved it.</p>
<p>Thanks,</p>
<p>Sarah Johnson Li<br>
Web Developer | Rollins College</p></div>Sarah Johnson Litag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-08-07T13:53:09Z2015-08-07T13:53:09ZEn dash removed/hidden from custom metadata field<div><p>Thank you for following up, Sarah. Please keep me posted on how
things go and let me know if you have any questions.</p>
<p>Thanks!</p></div>Ryan Griffithtag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-08-14T15:33:19Z2015-08-14T15:33:19ZEn dash removed/hidden from custom metadata field<div><p>Looks like we're in the clear! Thank you for your help Ryan.
:)</p></div>Sarah Johnson Litag:help-archives.hannonhill.com,2010-02-09:Comment/367112982015-08-14T15:46:20Z2015-08-14T15:46:20ZEn dash removed/hidden from custom metadata field<div><p>Thank you for following up, Sarah, I am glad to hear you were
able to resolve the issue.</p>
<p>I'm going to go ahead and close this discussion, please feel
free to comment or reply to re-open if you have any additional
questions.</p>
<p>Have a great day!</p></div>Ryan Griffith