Subject Re: [firebird-support] Fb 2.1, UTF8 DB, ASCII BLOB, SQLScale holds charset ID?
Author Martijn Tonies
>> I'm connecting with a characterset of UTF8, I'm opening
>> select * from mytable (including the text-blob)
>>
>> From what I can see, "SQLScale" in the SQLVAR
>> holds the characterset ID of the column, but for the ASCII
>> text blob, this also returns "4" (UTF8) and not "2" (ASCII).
>>
>> When retrieving and putting data, what is expected for
>> the engine and at the client side? UTF8 data or plain ASCII?
>
> You requested UTF8 (via connection param), you are getting UTF8. The
> engine does conversion for you.
>
> SY, SD.

Right, thanks.

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