PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value

Created on 10 September 2021, almost 3 years ago
Updated 16 March 2023, over 1 year ago

Problem/Motivation

I am trying to enter characters like 𑌮𑍇𑌘𑌸𑌨𑍍𑌦𑍇𑌶𑌪𑍍𑌰𑌦𑍀 (this are Grantha characters (see Wikipedia). When saving the node I get a fatal error.

Should these characters work?

PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\x91\x8C\xAE\xF0\x91...' for column `db`.`field_data_field_name_in_local_script`.`field_name_in_local_script_value` at row 1: INSERT INTO {field_data_field_name_in_local_script} (entity_type, entity_id, revision_id, bundle, delta, language, field_name_in_local_script_value, field_name_in_local_script_format) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 109978 [:db_insert_placeholder_2] => 196110 [:db_insert_placeholder_3] => work [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => 𑌮𑍇𑌘𑌸𑌨𑍍𑌦𑍇𑌶𑌪𑍍𑌰𑌦𑍀 [:db_insert_placeholder_7] => ) in field_sql_storage_field_storage_write() (line 610 of /var/www/html/modules/field/modules/field_sql_storage/field_sql_storage.module).

Steps to reproduce

Installed and enabled the module. Add "Node" to the whitelist.

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

🐛 Bug report
Status

Active

Version

1.0

Component

Code

Created by

🇮🇱Israel Amir Simantov

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.69.0 2024