Ross schreef:
> This sould seem to suggest that the a NCHAR(30) column would actually
> require 30 bytes of storage (as UTF8 has a single-byte code unit).
Eh? UTF-8 is a variable length characterset! UTF16 is fixed (and -in my
opinion- far better suited in most cases), as are all charactersets with
the digit 7 or 8 in position three (like WE8ISO... WE8DEC, US7ASCII)
> However, an example in Chapter 7 explicitly states that 90 bytes are
> required. I don't think the NLS_LENGTH_SEMANTICS parameter affects
> NCHAR, so which is correct?
>
For UTF-8, 90 byte in a NCHAR(30) column would be possible. Or
more (when the data containes Chinese BIG-5 characters - 4 byte each),
or less (US Ascii data would only use 30 byte).
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Mon Jul 10 2006 - 13:54:19 CDT
