Subject Re: [Firebird-Architect] Re: [firebird-support] Writing UTF16 to the database
Author Arno Brinkman
Hi,

> > Absolutely right. And look at the convolutions Microsoft did in Win32
> > (XP versions at least) to add GB18030 over their 16 bits unicode
> > representation. True, GB18030 will hit four bytes represented in UTF-8.
> > But it will also hit 4 bytes represented in UTF-16. By now people will
> > have understood I'm an advocate of UTF-8 as internal (db storage)
> > universal representation of all strings. ;-)
>
> Since what is stored internally can be compressed, what is stored does
> not matter, it's how it is managed that is the problem.

I have my question how good the compression (RLE) works on UTF-8 / UTF-16 or any
other character encoding. Using another kind of compression could also enlarge
the size of record-versions.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info