DBIx and MySQL's binary data type

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Got saddled with a project that involves utilizing DBIx for CRUD operations in a MySQL database. One of the fields is something I haven't had to deal with in Perl and particularly in DBIx. I have a binary(60) field in MySQL that will store a bcrypt hash for passwords. In some testing and discovery, I am having a hard time storing properly and ultimately authenticating passwords correctly. In my testing been using Crypt::Eksblowfish::Bcrypt. I've googled about for the morning and have unfortunately found nothing that applies to a best practice in the situation. Does anyone have any suggestions?

Comment on DBIx and MySQL's binary data type

Replies are listed 'Best First'.
Re: DBIx and MySQL's binary data type by Your Mother (Archbishop) on Apr 14, 2018 at 06:44 UTC
Are you using DBIx::Class::EncodedColumn::Crypt::Eksblowfish::Bcrypt? Following the doc? If you're still having problems, you should try to post a minimal example of your code. Sidebar: DBIx is not synonymous with DBIx::Class; DBIC is often used for short. There are a lot of disparate modules under the DBIx:: namespace.	[reply]