Subject | Re: [firebird-support] Fb 2.1, UTF8 DB, ASCII BLOB, SQLScale holds charset ID? |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2009-03-04T10:04:56Z |
> I'm connecting with a characterset of UTF8, I'm openingYou requested UTF8 (via connection param), you are getting UTF8. The
> 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?
engine does conversion for you.
SY, SD.