[Firebird-devel] PROPOSAL FB 3.0: Ditch the NONE as default charset

[Roman R. <ro...@ro...>]

Hi,

After some hot discussion in Firebird-Java, I want to propose to ditch 
the NONE as default character set for newly created databases when no 
database charset is specified.

The server/engine should read the config file and use the default 
character set which is specified there. The installer asks for this 
character set during installation and defaults the selection to the 
current character set of the environment (regional settings on Windows, 
LANG/LC_CTYPE environment vars on Linux).

Backward compatibility is achieved by falling back to NONE when nothing 
is specified in the config.

This change would allow Java and .NET clients default the connection 
charset to UTF-8 thus avoiding a situation when data is written in 
different charsets in heterogenous environments (e.g. Linux with default 
UTF-8 and Windows with default WIN1251).

The change is proposed for Firebird 3.0.

Roman Rokytskyy