Hello Roman

At 16/12/2002 11:53 +0000, you wrote:

>> I review it, and we fill chars to its length in output but not in
>> input, in input it come filled.
>
>Ok. I will check if we need to pad CHAR with spaces on output... I
>think server should do this on its own.

We don't need to do padding, but it is better is we do.

I make a test forcing output to SQL_VARYING when the field is SQL_TEXT, everything work ok, but the problem is that performance is the same or worse, even on remote connections over a LAN.

In the test, I use char(255) fields filled with 80 characters, and so if there is no padding, the communication contains 70% less information, but even with this difference, performance is better is field is padded by the driver.

This seems to be another problem with the character conversion stuff in the server.

Best Regards
Blas Rodriguez Somoza