The filename or extension is too long

How to manage and detect files which are not possible to download from Linux server into Windows local PC?
It seems I can download with another software but only inside a new folder. Composer extension is called PHPSpreadSheet

Is it defined file length inside Windows system as only inside a new folder can be downloaded?

As I understand some SFTP software support automatic detection and some do not ask. It means you can make mistake if you set ALL binary from a Linux server into Windows PC due to backup. Probably it will be Use this type for all file feature very risky if it is checked.

Default transfer type:

  1. Binary
  2. ASCII

How we know which type should be defined for ASCII as Linux servers use binary?