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 ------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
