Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#13 2016-11-28 19:11:03

jayrope
Plugin Author
From: Berlin
Registered: 2006-07-06
Posts: 687
Website Mastodon

Re: NON-ASCII obfuscated since MySQL/PHP "upgrade"

So …
I am being informed by the server people (it’s hostforweb.com, by the way, whom i worked with for 13+ years now), that Textpattern installs do not conform to true UTF-8, which they say is being enforced by mariaDB10, and therefore collations have to be turned back to latin1 to make them work, including (obviously) eventual data loss.
I am not so flattered about my host anymore.

Does anyone have a quality comment on this information?

Last edited by jayrope (2016-11-28 19:11:43)


A hole turned upside down is a dome, when there’s also gravity.

Offline

#14 2016-11-28 19:33:16

jayrope
Plugin Author
From: Berlin
Registered: 2006-07-06
Posts: 687
Website Mastodon

Re: NON-ASCII obfuscated since MySQL/PHP "upgrade"

Bloke wrote #303041:

EDIT: if your config.php uses utf8mb4, what happens if you switch it to utf8?

It doesn’t seem to make a difference. Most of my configs are plain utf8, no mb4. What’s teh difference?


A hole turned upside down is a dome, when there’s also gravity.

Offline

#15 2016-11-28 23:07:22

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,250
Website GitHub

Re: NON-ASCII obfuscated since MySQL/PHP "upgrade"

jayrope wrote #303062:

Most of my configs are plain utf8, no mb4. What’s teh difference?

The mb4 variant is “true” UTF-8 support — it can use up to four bytes, so all characters can be represented. I believe MySQL’s original utf8 only used three bytes so could only represent a subset of all the character sets in the world. Albeit this covered most of them anyway, so unless you’re into writing Klingon or Emoji, utf8 usually suffices.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#16 2016-11-29 00:21:48

jayrope
Plugin Author
From: Berlin
Registered: 2006-07-06
Posts: 687
Website Mastodon

Re: NON-ASCII obfuscated since MySQL/PHP "upgrade"

Yes, I’m fine with “just” utf8.

Now i set up a test site to see, what txp 4.6.2 initially sets up:

Upon running setup i get

“Warning: mysqli_real_connect(): Headers and client library minor version mismatch. Headers:50630 Library:100028 in /home/kliklak/public_html/mysqltest/textpattern/setup/txpsql.php on line 56”

and

“That went well! Textpattern database tables were created …“ etc.

Diagnostics show no errors, and these further details:

Charset (default/config): latin1/utf8mb4
character_set_client: latin1
character_set_connection: latin1
character_set_database: utf8
character_set_filesystem: binary
character_set_results: latin1
character_set_server: utf8
character_set_system: utf8
character_sets_dir: /usr/share/mysql/charsets/
17 Tables: textpattern is utf8mb4, txp_category is utf8mb4, txp_css is utf8mb4, txp_discuss is utf8mb4, txp_discuss_nonce is utf8mb4, txp_file is utf8mb4, txp_form is utf8mb4, txp_image is utf8mb4, txp_lang is utf8mb4, txp_link is utf8mb4, txp_log is utf8mb4, txp_page is utf8mb4, txp_plugin is utf8mb4, txp_prefs is utf8mb4, txp_section is utf8mb4, txp_token is utf8mb4, txp_users is utf8mb4

the complete database reports simply utf8 on collation, not utf8mb4.

So there we have a mix of collation again. Grmph.

I think a big part of my problems is related already to different older textpattern versions already. I guess i can somehow minimize trouble, when the first thing i do, is update them all to 4.6.2.


A hole turned upside down is a dome, when there’s also gravity.

Offline

Board footer

Powered by FluxBB