On 25-May-09, at 5:42 AM, Milan Babuskov wrote:

> Martijn Tonies wrote:
>>>>> Can "sqlscale" be filled with N where N is the number of
>>>>> characters in
>>>>> the result.
>>>> Can it?
>>> Yes, it can. However, I'm not sure this is a really good idea and I
>>> suggested an alternative in my post.
>>
>> Sorry, I guess I missed that...
>
> I believe he's refering to this message:
>
> http://tech.groups.yahoo.com/group/firebird-support/message/102355

An extra round trip to the server to get this for each char column in
a statement is really not much of a solution. Selecting the maximum
bytes per character set id and using the character set id in the
XSQLDA is better than that! You are replacing the single select
request when you connect with extra requests for every statement which
is a step backwards.

--
Brad