octet_length(char) doesn't behave as expected.

### Describe the bug

Hi there,

``select octet_length(char)`` doesn't behave as expected.

In the example below - in Postgres (``text`` column) the below SQL would return 25 as the result however in DataFusion (``StringArray`` column ) it just returns the original length of the values in ``n_name``.

```sql
select octet_length(n_name::char(25)) from nation;
```

I'm not sure if this is because the cast to a ``char(25)`` is not behaving as expected

### To Reproduce

create a StringColumn in DF, populate it with some values and run the following SQL on it.

```sql
select octet_length(n_name::char(25)) from nation;
```

### Expected behavior

Should return 25, but it returns the length of each of the values in the column.

### Additional context

_No response_

Start with the SQL reproduction using a DataFusion StringArray and compare octet_length(n_name::char(25)) with PostgreSQL's result. Trace the cast to char(25) and octet_length behavior, then add coverage showing that the expression returns 25 for the reproduced values.

Written by the indexing model from the issue text.