MySQL Forums
Forum List  »  Newbie

mysql Ver 8.0.32-0ubuntu0.20.04.2 issue invalid utf8mb4 character string
Posted by: christophe offroy
Date: February 15, 2023 08:48AM

Hi,
i have a problem since the new 8.0.32 lib were installed.
when i do a select on a column with a comparaison on a literal with accent i have the error above.

schema description :
CREATE DATABASE `btspdch1` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */ /*!80016 DEFAULT ENCRYPTION='N' */

table description :
CREATE TABLE `cof` (
`c` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

i do an insert:
INSERT INTO `cof` (`c`) VALUES ('Annulé');

when i do a select :
SELECT * FROM `cof` where c='Annulé' ==> one row is return
SELECT * FROM `cof` where c='Annule' ==> why one row is return because i check on "Annule"

+-------------------------------+--------------------+
| Variable_name | Value |
+-------------------------------+--------------------+
| collation_connection | utf8mb4_0900_ai_ci |
| collation_database | utf8mb4_unicode_ci |
| collation_server | utf8mb4_unicode_ci |
| default_collation_for_utf8mb4 | utf8mb4_0900_ai_ci |
+-------------------------------+--------------------+


+--------------------------+--------------------------------+
| Variable_name | Value |
+--------------------------+--------------------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8mb3 |
| character_sets_dir | /usr/bin/share/mysql/charsets/ |


My question :
why the comparison between the c column and the literal 'Annulé' don't check accent ?

Options: ReplyQuote


Subject
Written By
Posted
mysql Ver 8.0.32-0ubuntu0.20.04.2 issue invalid utf8mb4 character string
February 15, 2023 08:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.