Re: Any chance to surpass 4000 character limit?

From: Vladimir M. Zakharychev <>
Date: Tue, 27 Jan 2009 00:50:20 -0800 (PST)
Message-ID: <>

On Jan 27, 11:14 am, wrote:
> On 26 Jan., 18:48, joel garry <> 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.


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

Original text of this message