>>>> PS: this is all using the C fbclient library and I'm setting the
>>>>> connection character set using isc_dpb_lc_ctype in my connection
>>>>> parameters.
>>>> I've seen this when using IBObjects, can someone else confirm this too?
>>> Both, DBW and isql give the following result:
>>>
>>> ax
>>>
>>>
>>> when doing the following query:
>>>
>>> select c || 'x' from t2
>>>
>>>
>>> where c is a CHAR(1) in a UTF8 database. Firebird 2.1.2.
>>
>> But when using || 'x', does this stay a CHAR or does it become
>> VARCHAR?
>
> At least trailing spaces in the field c should be preserved, if there
> are any, right?
>
> So, a:
>
> select c || 'x' from t2
>
>
> could have as output, e.g.
>
> a x
>
>
> if there are 2 trailing spaces.

Right, I guess they should, so it would be a client side error then?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com