V4RB, Jon, project /// More explanation.

[Ruslan Zasukhin]

On 9/16/04 2:06 AM, "Ivan Smahin" <IvanSmahin at public.kherson.ua> wrote:

>>> You make the final decision, of course. But as you said, we are *all*
>>> developers on this list and would prefer to deal with bytes, not
>>> characters. I assure you that if you mix the meaning of the number
>>> parameter as a function of the type of encoding there will be lots of
>>> problems (both with existing users and new users). And what happens
>>> to existing data space if you change the encoding? Why create this
>>> headache?
> 
> RZ> Okay, we will think one more about this.
> 
> RZ> Just also exists SQL standard
> 
> RZ> Also Ivan says that other DBMS "think" in chars.
> 
> Frankly saying other DBMS prefer to mix such terms as
> characters and bytes. It seems - just for better understanding. :)
> 
> On the one hand it's no difference for one-byte code-pages.
> So, here is ( char(10) ) no problem to say 10 bytes or 10 characters.
> 
> On the other hand we need to differ bytes and characters case
> multi-byte codepages.
> 
>    For instance:
> 
>    It is from MS-SQL manual:
> 
>    char:
>         Fixed-length non-Unicode character data with a maximum length of 8,000
> characters.
> 
>         Fixed-length non-Unicode character data with length of n bytes.
>         n must be a value from 1 through 8,000. Storage size is n bytes.
> 
> 
>    nchar(n):
>         Fixed-length Unicode data with a maximum length of 4,000 characters.
>    
>         Fixed-length Unicode character data of n characters.
>         n must be a value from 1 through 4,000. Storage size is two times n
> bytes.
> 
> 
>    Oracle is much more correct as usual:
> 
>    CHAR(size)
>     Fixed-length character data of length size bytes.
>     Maximum size is 2000 bytes. Default and minimum size is 1 byte.
> 
>    NCHAR(size)
>      Fixed-length character data of length size characters or bytes,
>      depending on the choice of national character set.
>      Maximum size is determined by the number of bytes required to store each
> character,
>      with an upper limit of 2000 bytes.
>      Default and minimum size is 1 character or 1 byte, depending on the
> character set.

Actually Oracle looks to choose the "confusing" way, as Jon says.
They mix bytes and chars "depending on the character set".

Hey, guys, MS and Oracle have limits for String field in 4K and 2K,
Valentina gives you 64KB! :-)


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------