|Subject||Re: [firebird-support] Fb 2.1, UTF8 DB, ASCII BLOB, SQLScale holds charset ID?|
>> I'm connecting with a characterset of UTF8, I'm openingRight, thanks.
>> 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.
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum: