Export (0) Print
Expand All
Expand Minimize

2.1.1020 Part 4 Section 3.17.7.209, MIDB

a. The standard states that MIDB is intended for use with languages that use the double-byte character set (DBCS), whereas MID is intended for use with languages that use the single-byte character set (SBCS).

In Office, MIDB is intended for use with languages that use the double-byte character set (DBCS), whereas MID is intended for use with any language.

b. The standard states if start-pos < 0, #VALUE! is returned.

Office returns #VALUE! if start-pos < 1.

c. The standard states that if the start-pos argument is greater than the length of the string argument, or if the start-pos argument and the number- bytes argument combined exceed the length of the string argument, the whole of string shall be extracted.

In Office, if start-pos is greater than the length of string the empty string is returned. If start-pos and number-bytes combined exceeds the length of string, the remainder of string starting at byte position start-pos is returned.

d. The standard specifies the return value as a string containing number-bytes-worth of characters from string, starting at character position start-pos.

Office returns a string containing number-bytes-worth of characters from string, starting at byte position start-pos.

e. The standard does not specify behavior of MIDB when default language supports DBCS and when it does not support DBCS.

In Office, when the default language supports DBCS, MIDB counts each double-byte character as 2 bytes, and each single-byte character as 1. When the default language does not support DBCS, MIDB counts each character as 1 byte.

f. The standard does not specify which languages support DBCS.

In Office, the languages that support DBCS include Japanese, Chinese (Simplified), Chinese (Traditional), and Korean.

Show:
© 2014 Microsoft