Re: [Firebird-devel] UTF8 Encoding and Decoding

[Adriano d. S. F. <adr...@gm...>]

On 27/04/2011 19:28, Support List wrote:
> I am doing a new major release of IB Objects soon and I want to get
> confirmation of some things before I finalize it.
>
> I have some scenarios that I would like to know what to do about.
> There are a total of 9 possible combinations of 3 aspects.
>
> Aspect #1: Database created with a default character set of ??? or NONE.
> Aspect #2: Database connected to with a character set of ??? or NONE.
> Aspect #3: Columns given their own character set of ??? or left blank.
>
> I need to know what happens with each possible combination.
>
> For example, if I have a database that was created with default character
> set of NONE and there is a column in it defined as UTF8. Then, when I
> connect to the database using character set of UTF8, how will the data be
> sent to the client? Will all of it be transliterated into UTF8?
>
Database charset is used only for one purpose: default character set in 
DDL commands.

> Have there been any changes in how this has been handled from version to
> version?
>
Probably some inconsistency here and there, but general idea is the same 
since 1.5.

Data is transliterated from its charset to client charset and vice-versa.

NONE/OCTETS -> something: data is validated accordingly to something
something -> NONE/OCTETS: nothing is done
something1 -> something2: data is transliterated


Adriano