[SPARK-48739][SQL] Disable writing collated data to file formats that don't support them in non managed tables

[stefankandic]

What changes were proposed in this pull request?

Disable writing collated types to data sources that don't support them. However, spark managed tables should still work as the schema is in HMS and not in the file itself.

Why are the changes needed?

Right now, when users write a collated type directly to json, text, orc.. they will not see that collation when reading back.

Does this PR introduce any user-facing change?

No.

How was this patch tested?

Added new UTs

Was this patch authored or co-authored using generative AI tooling?

No.