Re: How To Represent varchar(max) in DBIx::Class

Hi, try

{ data_type => "varchar", is_nullable => 1, size => "max" }
#                                                   ^   ^
[download]

... that's what the Perl error is reporting.

That may lead to a DBIx::Class error, I don't know whether the syntax is supported.

I wasn't familiar with VARCHAR(MAX) so I looked it up; it seems it's not recommended except in the specific case of having data of potentially large size (e.g. VARCHAR(MAX) vs VARCHAR(255)). Is that your case?

Hope this helps!

The way forward always starts with a minimal test.

Comment on Re: How To Represent varchar(max) in DBIx::Class Select or Download Code

Replies are listed 'Best First'.
Re^2: How To Represent varchar(max) in DBIx::Class by phildeman (Scribe) on Jan 08, 2018 at 02:13 UTC
Yep, that worked. That is it got rid of the error. However, regarding you point about varchar(max) not being supported, I read that too. I will see if it works. If not, I will see if my DBA can change the data size to accommodate this package. Thanks again for your help. -Phil-	[reply]