Re: Any chance to surpass 4000 character limit?

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Tue, 27 Jan 2009 00:50:20 -0800 (PST)
Message-ID: <622398c7-72b8-49d1-94c5-f002b180fbbf_at_k36g2000pri.googlegroups.com>

On Jan 27, 11:14 am, stegem..._at_naviga.de wrote:
> On 26 Jan., 18:48, joel garry <joel-ga..._at_home.com> wrote:
>
> > Amazing how many times I've heard this, and it has turned out to be
> > wrong.
>
> Hi Joel,
>
> our applications are created for German government and administration.
> The chance that German government and administration procedures ever
> might be adopted by any other administration in the world are zero,
> believe me.
>
> Cheers
> K-V

Still, your database might eventually switch from ISO-8859-1 character encoding to, say, UTF-8 and there you have it: umlauts will occupy two bytes in UTF-8 instead of one in ISO-8859-1, and your maximum string length in characters will fall below 4000. Since maximum code point length in UTF-8 is 4 bytes, you can reliably fit at least 1000 characters into 4000 bytes, but a string of any length beyond 1000 characters is not guaranteed to fit. With UTF-32 every character occupies 4 bytes regardless, so maximum length of any string in characters is 1000.

Regards,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Tue Jan 27 2009 - 02:50:20 CST