[Koha-bugs] [Bug 34549] The cataloguing editor allows you to input invalid data

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34549

--- Comment #21 from David Cook <dcook at prosentient.com.au> ---
I tried to manually insert Latin-1 data with a byte that doesn't exist in UTF-8
and I couldn't manually insert it into the database either using the ORM:

DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st
execute failed: Incorrect string value: '\xF6irm.<...' for column
`koha_kohadev`.`biblio_metadata`.`metadata` at row 1 at
/kohadevbox/koha/Koha/Object.pm line 170
Invalid value passed, biblio_metadata.metadata=\xF6irm.<... expected type is
string

I also couldn't do it using the db handle via DBIx::Class more directly:

{UNKNOWN}: DBI Exception: DBD::mysql::st execute failed: Incorrect string
value: '\xF6irm.<...' for column `koha_kohadev`.`biblio_metadata`.`metadata` at
row 1  at /usr/share/perl5/DBIx/Class/Schema.pm line 1118.
        DBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x55aa1477f670),
"DBI Exception: DBD::mysql::st execute failed: Incorrect strin"...) called at
/usr/share/perl5/DBIx/Class/Storage.pm line 113
       
DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::mysql=HASH(0x55aa1b4856c8),
"DBI Exception: DBD::mysql::st execute failed: Incorrect strin"...) called at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1623
        DBIx::Class::Storage::DBI::__ANON__("DBD::mysql::st execute failed:
Incorrect string value: '\\xF6i"..., DBI::st=HASH(0x55aa1d031f20), undef)

-- 
You are receiving this mail because:
You are watching all bug changes.