Subject Re: [firebird-support] Re: usable characters for varchar and memos
Author Milan Babuskov
Anderson Farias wrote:
> ----- Original Message -----
> From: "Milan Babuskov"
>> You *don\t* have to have the same character set for entire database!
>> For non-encrypted columns, use the most appropriate charset, for example
>> WIN1252 or ISO8859_1. For encrypted columns, use OCTETS.
>
> But you have to connect to DB specifying a charset (only one), so how that
> work?

Connect with WIN1252. Firebird does the transliteration where needed,
and (IIRC) leaves OCTETS as-it-is, so you simple read it in unchanged
binary form.

--
Milan Babuskov
http://www.flamerobin.org