Ygthkb

Has a sovereign Communist government ever run, and conceded loss, on a fair election?

How to roleplay my character's ethics according to the DM when I don't understand those ethics?

Caulking a corner instead of taping with joint compound?

Naming Characters after Friends/Family

I can't die. Who am I?

Commonest[] function doesn't actually show commonest elements

How can you calculate the inverse of signature S, while you cannot do it in ECC to calculate private key from public key?

Convert an array of objects to array of the objects' values

Sundering Titan and basic normal lands and snow lands

What is the meaning of "producing negative zeroes" in a system that doesn't support it?

Does the US political system, in principle, allow for a no-party system?

How do you make a gun that shoots melee weapons and/or swords?

Searching for a string that contains the file name

How spaceships determine each other's mass in space?

Ultrafilters as a double dual

Why aren't there more gauls like Obelix?

How do you write a macro that takes arguments containing paragraphs?

Number of folds to form a cube, using a square paper?

How can friction do no work in case of pure rolling?

Effect of "wrong" driver with slightly long RS-485 stubs

Remove object from array based on array of some property of that object

Practical reasons to have both a large police force and bounty hunting network?

Can a space-faring robot still function over a billion years?

Is divide-by-zero a security vulnerability?

How to use Unicode chars on PHPMyAdmin?

How to display database structure in phpMyAdmin?PhpMyAdmin Missing parameterHow to import big sql file in PhpmyadminHow to use 2 auto increment columns in MySQL phpmyadminPHPMyAdmin - Missing value in the formCannot use phpmyadmin in XAMPPIssues regarding phpMyAdmin - character setIncrease AUTO_INCREMENT value in phpMyAdminDoes phpMyAdmin only works with HTTPS?phpMyAdmin 4.8 vs 5.0 comparison

0

On a WordPress site I want to replace " !" and " ?" by " !" and " ?". The challenge is that the replacement string not uses a common space char but a thin space char (U+2009).

PHPMyAdmin is used for database editing with this query:

UPDATE wp_posts SET post_content = REPLACE (post_content,' !',' !');

(Yes, it's the correct thin space char, but Courier is a fixed-width font not showing a difference.)

It seems that PHPMyAdmin is not correctly handling the special char, because simulating the query delivers zero hits.

But trying another replace query works, so the statement should be correct. Tables are using "utf8mb4_unicode_ci" as collation, which seems to be the default and correct setting of WordPress. Database server is MariaDB (10.1.26).

I'm not familiar enough how to specify Unicode chars in SQL queries. Can someone help me out there?

mariadb phpmyadmin wordpress

share

asked 9 mins ago

TobyToby

1

New contributor

Toby is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

On a WordPress site I want to replace " !" and " ?" by " !" and " ?". The challenge is that the replacement string not uses a common space char but a thin space char (U+2009).

PHPMyAdmin is used for database editing with this query:

UPDATE wp_posts SET post_content = REPLACE (post_content,' !',' !');

(Yes, it's the correct thin space char, but Courier is a fixed-width font not showing a difference.)

It seems that PHPMyAdmin is not correctly handling the special char, because simulating the query delivers zero hits.

But trying another replace query works, so the statement should be correct. Tables are using "utf8mb4_unicode_ci" as collation, which seems to be the default and correct setting of WordPress. Database server is MariaDB (10.1.26).

I'm not familiar enough how to specify Unicode chars in SQL queries. Can someone help me out there?

mariadb phpmyadmin wordpress

share

asked 9 mins ago

TobyToby

1

New contributor

Toby is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

On a WordPress site I want to replace " !" and " ?" by " !" and " ?". The challenge is that the replacement string not uses a common space char but a thin space char (U+2009).

PHPMyAdmin is used for database editing with this query:

UPDATE wp_posts SET post_content = REPLACE (post_content,' !',' !');

(Yes, it's the correct thin space char, but Courier is a fixed-width font not showing a difference.)

It seems that PHPMyAdmin is not correctly handling the special char, because simulating the query delivers zero hits.

But trying another replace query works, so the statement should be correct. Tables are using "utf8mb4_unicode_ci" as collation, which seems to be the default and correct setting of WordPress. Database server is MariaDB (10.1.26).

I'm not familiar enough how to specify Unicode chars in SQL queries. Can someone help me out there?

mariadb phpmyadmin wordpress

share

asked 9 mins ago

TobyToby

1

New contributor

Toby is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

UPDATE wp_posts SET post_content = REPLACE (post_content,' !',' !');

share

asked 9 mins ago

TobyToby

1

New contributor

Toby is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 9 mins ago

TobyToby

1

New contributor

Toby is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 9 mins ago

TobyToby

1

New contributor

Toby is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 9 mins ago

TobyToby

1