[Enhancement]: test collection name more than 64 characters

[hnwyllmm]

Description

As we use a table to record the meta information of collection, so the length of collection name can be more than 64 characters now. But there's no integration test case to cover this scenario.
Currently we have a test case file: tests/unit_tests/test_collection_name_validation.py.
Refer to doc for the details of sdk_collections meta table solution.

[NTLx]

Hi! I would like to work on this issue as part of the Developer Activities: Call for Participation. Please assign it to me.