Index

A

Alnum class 2-11, 2-13, 4-88

Alpha class 2-11, 2-13, 4-88, 4-90, 4-113, 4-115

Alphabetic character

case ignored 2-13, 4-88, 4-90, 4-113, 4-115

definition of 2-11

lowercase 2-11, 2-13, 4-101, 4-125

uppercase 2-11, 2-13, 4-109, 4-133

Array size

multibyte-character string 2-40

wide-character string 2-41

ASCII code set 2-4

Asian character 1-22

B

Blank character 2-12, 4-74

See also Horizontal white space.

Blank class 2-12, 2-13, 4-16, 4-18, 4-25, 4-28, 4-36, 4-41, 4-93, 4-117, 4-155, 4-166, 4-168, 4-206, 4-212

Buffer-size estimate

case conversion 2-16, 2-23, 4-11, 4-49

code-set conversion 2-23, 2-40, 4-49

C

Carriage-return character 2-12

See also Vertical white space.

Case conversion

buffer-size estimate 2-16

description of 2-14

INFORMIX-GLS functions for 4-8

lowercase to uppercase 4-188, 4-193

optimizing 2-20

uppercase to lowercase 4-185, 4-191

CHAR data type

See Character; Character string.

Character

7-bit 2-4

8-bit 2-4

alphabetic. See Alphabetic character.

blank. See Blank character.

case conversion 2-14

classifying. See Character classification.

comparing 2-34

control. See Control character.

digit. See Digit character.

graphical. See Graphical character.

hexadecimal digit. See Hexadecimal-digit character.

lowercase. See Lowercase character.

multibyte. See Multibyte character.

operations on 2-10

printable. See Printable character.

punctuation. See Punctuation character.

searching for 2-33

single-byte. See Single-byte character.

sorting 2-34

space. See Space character.

types of 2-4

uppercase. See Uppercase character.

visible 4-99, 4-123

wide. See Wide character.

Character classification

alnum class 2-11, 4-88

alpha class 2-11, 4-88, 4-90, 4-113, 4-115

blank class 2-12, 4-93, 4-117

cntrl class 2-12, 4-95, 4-119

description of 2-10

digit class 2-11, 4-88, 4-97, 4-113, 4-121

error-checking examples 1-21

graph class 2-12, 4-99, 4-123

INFORMIX-GLS functions for 4-7

lower class 2-11, 4-101, 4-125

print class 2-12, 4-103, 4-127

punct class 2-12, 4-105, 4-129

space class 2-12, 4-107, 4-131

testing for 2-13

upper class 2-11, 4-109, 4-133

xdigit class 2-11, 4-111, 4-135

Character operation

case conversion 2-14

character classification 2-10

code-set conversion 2-21

INFORMIX-GLS functions for 2-10

Character processing 2-3, 4-6

Character string

casting to multibyte string 2-7

comparing 2-34

complementary 4-153, 4-204

concatenating 2-31

conversion of 3-11

copying 2-32

date 3-7

date/time 3-7

deallocating 2-42

formatting of 3-12

length of 2-32

length-terminated 2-37

memory management 2-40, 2-41

money 3-5

null-terminated 2-37

number 3-4

operations on 2-29

processing of 2-31

searching 2-33

sorting 2-34

string traversal 2-29

termination of 2-37

See also Multibyte-character string; Wide-character string.

Charmap 12

Client application

See ESQL/C client application; DataBlade client application.

Client locale 1-10, 1-11, 1-19

CLIENT_LOCALE environment variable 1-11

Cntrl class 2-12, 2-13, 4-95, 4-119

Code point 2-4, 2-34

Code set 2-4, 2-7

ASCII 2-4

character classes 2-10

code-set collation order 2-34

converting. See Code-set conversion.

default 2-10

destination 2-21, 4-13, 4-45, 4-49, 4-51

ISO8859-1 2-10

Microsoft 1252 2-10

multibyte 2-5, 2-28

name of 2-24, 4-13, 4-46, 4-50, 4-51

non-state dependent 2-25

single-byte 2-4, 2-28, 4-51

source 2-21, 4-13, 4-45, 4-49, 4-51

state-dependent 2-25

Code-set collation order 2-34

Code-set conversion

buffer-size estimate 2-23, 2-40

conversion table 2-28, 4-51

determining if needed 2-21, 4-13

fragmented string 2-26

INFORMIX-GLS functions for 4-7

optimizing 2-28

performing 4-45

single-byte characters 4-51

state-dependent code sets 2-25

subdirectory for files 1-14, 1-23

support for 2-21

unfragmented string 2-26

Code-set name registry 2-24

COLLATE locale category. See LC_COLLATE locale-file category.

Collation

code-set collation order 2-34

definition of 2-34

localized collation order 2-34, 4-147, 4-199

types of 2-34

Comment icons Intro-7

Compiler

built-in scaling 2-4, 2-7, 2-30

options. See Compiler options.

Compiler option

-I 1-15, 1-18

-L 1-16

-lixgls 1-16

Complementary string 4-153, 4-204

Compliance, with industry standards Intro-15

Concatenation

description of 2-31

multibyte-character strings 2-31, 4-142, 4-159

wide-character strings 2-31, 4-195, 4-208

Constant

IFX_GL_EINVAL 2-43, 2-44, A-3

IFX_GL_NO_LIMIT 2-38

IFX_GL_NULL 2-38

Control character 2-12, 2-13, 4-95, 4-119

Conversion

date strings 4-15

date/time strings 4-24

definition of 3-9

INFORMIX-GLS functions for 3-11

money strings 4-35

number strings 4-40

time strings 4-24

wide-character string to multibyte-character string 4-221

See also Case conversion; Code-set conversion; Formatting.

Converting

date value to string 4-15

date/time value to string 4-24

money value to string 4-35

number value to string 4-40

string to date value 4-53

string to date/time value 4-61

string to money value 4-71

string to number value 4-77

string to time value 4-61

time value to string 4-24

conv_state_t structure 2-25, 4-47

Copying

multibyte-character string 2-32, 4-150, 4-162

wide-character string 2-32, 4-201, 4-210

CTYPE locale category. See LC_CTYPE locale-file category.

Currency data. See Monetary data.

Currency symbol 3-6, 4-74

current processing 1-11

Current processing locale 1-11, 1-18, 1-21, 2-24, 2-41, 4-86

D

Data formatting 3-3, 4-9

Database locale 1-10, 1-11, 1-19

DataBlade client application

compiling 1-15

current processing locale 1-11

initializing INFORMIX-GLS 1-19, 4-86

linking INFORMIX-GLS 1-15

localizing 1-9

DataBlade UDR

compiling 1-16

current processing locale 1-11

initializing INFORMIX-GLS 1-19, 4-86

linking INFORMIX-GLS 1-16

localizing 1-9

MI_SERVBUILD compiler flag 1-18

Date data

alternative digits for 3-8

converting 4-15

era names 3-8

field width 4-22, 4-58

format string 4-16, 4-54

formatting 4-53

formatting and conversion functions 4-10

formatting directives for 4-18, 4-20, 4-55, 4-57

locale category for 3-7

locale-specific formats 3-7

month names 3-8

precision 4-58

SQL data types for 3-4

weekday names 3-8

See also Date/time data.

Date string 3-7

Date/time data

alternative digits for 3-8

A.M. equivalent 3-8

converting 4-24

field width 4-32, 4-68

format string 4-25, 4-62

formatting 4-61

formatting and conversion functions 4-10

formatting directives for 4-27, 4-30, 4-63, 4-66

locale category for 3-7

locale-specific formats 3-7

precision 4-68

P.M. equivalent 3-8

SQL data types for 3-4

See also Date data.

Date/time string 3-7

DBCENTURY environment variable 4-19, 4-21, 4-29, 4-31

DBDATE environment variable 4-16, 4-21, 4-31, 4-54, 4-58, 4-67

DBMONEY environment variable 4-36, 4-72

DBTIME environment variable 4-25, 4-31, 4-62, 4-67

DB_LOCALE environment variable 1-11

DECIMAL data type

See Monetary data; Numeric data.

Decimal separator 3-5, 3-6, 4-75

Default locale 1-11, 3-11, 3-13

Digit character

decimal number 2-11, 2-13, 4-88, 4-90, 4-97, 4-113, 4-115, 4-121

hexadecimal number 2-11, 2-13, 4-111, 4-135

Digit class 2-11, 2-13, 4-88, 4-97, 4-113, 4-121

-DMI_SERVBUILD compiler option 1-18

Documentation conventions

icon Intro-7

typographical Intro-6

Documentation notes Intro-14

Documentation, related Intro-14

Documentation, types of

documentation notes Intro-14

error message files Intro-13

machine notes Intro-14

printed manuals Intro-13

related reading Intro-14

release notes Intro-14

E

End-user format 3-4

English locale

See Default locale.

Error handling functions 4-6

Error message files Intro-13, 1-12

Error messages

internationalizing 1-7

list of error numbers A-1

retrieving error numbers 1-20, 4-137

See also individual function names.

Error number 4-137, A-1

ESQL/C client application

compiling 1-14

current processing locale 1-11

initializing INFORMIX-GLS 1-19, 4-86

linking INFORMIX-GLS 1-14

localizing 1-9

Exception handling 1-20, 4-137

F

Feature icons Intro-8

Features, product Intro-4

Field width

of date string 4-22, 4-58

of date/time string 4-32, 4-68

of money string 4-38, 4-75

of number string 4-43, 4-81

Field width and precision

of date 4-58

of datetime 4-68

Fill character 4-74

finderr utility Intro-13

first_frag field 2-25, 4-47

FLOAT data type

See Numeric data.

Format string 3-10

date to string 4-54

date/time to string 4-62

money to string 4-72

number to string 4-78

string to date 4-16

string to date/time 4-25

string to money 4-36

string to number 4-41

string to time 4-25

time to string 4-62

Formatting

date values 4-53

date/time values 4-61

definition of 3-9

INFORMIX-GLS functions for 3-12, 4-9

money values 4-71

number values 4-77

time values 4-61

See also Conversion.

Formatting directive

date strings 4-55, 4-56

date values 4-18, 4-20

date/time strings 4-63, 4-65

date/time values 4-27, 4-29

definition of 3-10

Informix compatible 4-21, 4-31, 4-58, 4-67

modified 4-20, 4-29, 4-56, 4-65, 4-74, 4-80

money strings 4-73, 4-74

money values 4-37

number strings 4-79, 4-80

number values 4-42

purpose in conversion 3-11

purpose in formatting 3-12

See also Type specifier.

Form-feed character 2-12

See also Vertical white space.

Fragmented string 2-25, 2-26

G

Global Language Support. See GLS.

GLS locale. See Locale.

gls.h header file 1-14, 2-6, 2-8, 4-138, A-1

GL_DATE environment variable 4-16, 4-54

GL_DATETIME environment variable 4-25, 4-62

gl_mchar_t data type 2-6

gl_wchar_t data type 2-8

Graph class 2-12, 2-13, 4-99, 4-123

Graphical character 2-12, 2-13, 4-99, 4-123

Grouping information 3-5, 3-6

Groupings separator. See Thousands separator.

H

Header file

directory location 1-14

ifxgls.h 1-13, 1-15, 1-17

Hexadecimal-digit character 2-11, 2-13, 4-79, 4-111, 4-135

Horizontal white space

definition Intro-11

definition of 2-12

in format strings 4-16, 4-18, 4-25, 4-36, 4-41

representation of Intro-11

testing for 2-13, 4-93, 4-107, 4-117, 4-131

trailing 4-155, 4-166, 4-168, 4-206, 4-212

I

I18n abbreviation 1-4

Icons

comment Intro-7

feature Intro-8

platform Intro-8

ifxgls.h header file 1-13, 1-14, 1-15, 1-17, 2-6, 2-8

IFX_GL_CASE_CONV_DST_BYTES macro 2-17, 4-186, 4-189

ifx_gl_case_conv_outbuflen() function 2-16, 2-40, 4-11

IFX_GL_CASE_CONV_SRC_BYTES macro 2-17, 4-186, 4-189

ifx_gl_convert_datetime() function 3-10, 3-11, 4-24

ifx_gl_convert_date() function 3-10, 3-11, 4-15

ifx_gl_convert_money() function 3-10, 3-11, 4-35

ifx_gl_convert_number() function 3-10, 3-11, 4-40

ifx_gl_conv_needed() function 2-21, 2-24, 4-13

ifx_gl_cv_mconv() function 2-22, 2-24, 2-25, 4-45

ifx_gl_cv_outbuflen() function 2-22, 2-23, 2-24, 2-40, 4-49

ifx_gl_cv_sb2sb_table() function 2-24, 2-28, 4-51

IFX_GL_EINVAL constant 2-43, 2-44, A-3

ifx_gl_format_datetime() function 3-10, 3-12, 4-61

ifx_gl_format_date() function 3-10, 3-12, 4-53

ifx_gl_format_money() function 3-10, 3-12, 4-71

ifx_gl_format_number() function 3-10, 3-12, 4-77

ifx_gl_getmb() function 1-22, 4-83

ifx_gl_init() function 1-18, 1-21, 4-86

ifx_gl_ismalnum() function 2-13, 4-88

ifx_gl_ismalpha() function 2-13, 4-90

ifx_gl_ismblank() function 2-13, 4-93

ifx_gl_ismcntrl() function 2-13, 4-95

ifx_gl_ismdigit() function 2-13, 4-97

ifx_gl_ismgraph() function 2-13, 4-99

ifx_gl_ismlower() function 2-13, 4-101

ifx_gl_ismprint() function 2-13, 4-103

ifx_gl_ismpunct() function 2-13, 4-105

ifx_gl_ismspace() function 2-13, 4-107

ifx_gl_ismupper() function 2-13, 4-109

ifx_gl_ismxdigit() function 2-13, 4-111

ifx_gl_iswalnum() function 2-13, 4-113

ifx_gl_iswalpha() function 2-13, 4-115

ifx_gl_iswblank() function 2-13, 4-117

ifx_gl_iswcntrl() function 2-13, 4-119

ifx_gl_iswdigit() function 2-13, 4-121

ifx_gl_iswgraph() function 2-13, 4-123

ifx_gl_iswlower() function 2-13, 4-125

ifx_gl_iswprint() function 2-13, 4-127

ifx_gl_iswpunct() function 2-13, 4-129

ifx_gl_iswspace() function 2-13, 4-131

ifx_gl_iswupper() function 2-13, 4-133

ifx_gl_iswxdigit() function 2-13, 4-135

ifx_gl_lc_errno() function 1-20, 1-21, 2-14, 4-137, A-1

See also Error messages.

ifx_gl_mblen() function 2-29, 4-140

ifx_gl_mbscat() function 2-31, 4-142

ifx_gl_mbschr() function 2-33, 4-145

ifx_gl_mbscoll() function 2-35, 4-147

ifx_gl_mbscpy() function 2-32, 4-150

ifx_gl_mbscspn() function 2-33, 4-152

ifx_gl_mbslen() function 2-32, 4-155

ifx_gl_mbsmbs() function 2-33, 4-157

ifx_gl_mbsncat() function 2-31, 4-159

ifx_gl_mbsncpy() function 2-32, 4-162

ifx_gl_mbsnext() function 2-29, 4-140, 4-164

ifx_gl_mbsntsbytes() function 2-32, 4-166

ifx_gl_mbsntslen() function 2-32, 4-168

ifx_gl_mbspbrk() function 2-33, 4-170

ifx_gl_mbsprev() function 2-29, 4-172

ifx_gl_mbsrchr() function 2-33, 4-174

ifx_gl_mbsspn() function 2-33, 4-176

ifx_gl_mbstowcs() function 1-24, 2-9, 4-179

ifx_gl_mbtowc() function 2-9, 4-181

ifx_gl_mb_loc_max() function 2-16, 2-40, 4-84, 4-139, 4-225

IFX_GL_MB_MAX macro 2-16, 2-23, 2-40, 4-84, 4-225

IFX_GL_NO_LIMIT constant 2-38

IFX_GL_NULL constant 2-38

IFX_GL_PROC_CS macro 2-21, 2-22, 2-24, 4-13, 4-46, 4-50, 4-51

ifx_gl_putmb() function 1-22, 4-183

ifx_gl_tomlower() function 2-15, 4-185

ifx_gl_tomupper() function 2-15, 4-188

ifx_gl_towlower() function 2-15, 4-191

ifx_gl_towupper() function 2-15, 4-193

ifx_gl_wcscat() function 2-31, 4-195

ifx_gl_wcschr() function 2-33, 4-197

ifx_gl_wcscoll() function 2-35, 4-199

ifx_gl_wcscpy() function 2-32, 4-201

ifx_gl_wcscspn() function 2-33, 4-203

ifx_gl_wcslen() function 2-30, 2-32, 4-206

ifx_gl_wcsncat() function 2-31, 4-208

ifx_gl_wcsncpy() function 2-32, 4-210

ifx_gl_wcsntslen() function 2-32, 4-212

ifx_gl_wcspbrk() function 2-33, 4-214

ifx_gl_wcsrchr() function 2-33, 4-216

ifx_gl_wcsspn() function 2-33, 4-218

ifx_gl_wcstombs() function 1-24, 2-9, 4-221

ifx_gl_wcswcs() function 2-33, 4-223

ifx_gl_wctomb() function 2-9, 4-225

Include file. See Header file.

Industry standards, compliance with Intro-15

INFORMIXDIR environment variable 1-10, 1-12, 1-14, 2-24

INFORMIX-GLS library

allocating memory for 1-22

character processing 2-3

compatibility 1-7

data formatting 3-3

error number 4-137

gl_mchar_t data type 2-6

gl_wchar_t data type 2-8

handling exceptions of 1-20, 4-137

initializing 1-18

optimization of 1-23

required directories 1-14

single-byte characters 2-5

stream I/O 1-22

string-processing functions 2-31

Initialization functions 4-6

INT8 data type

See Numeric data.

INTEGER data type

See Numeric data.

International monetary format 3-6, 4-37, 4-73

Internationalization

character processing 2-3

data formatting 3-3

definition of 1-4

INFORMIX-GLS library and 1-6

ISO8859-1 code set 2-10

L

L10n abbreviation 1-9

last_frag field 2-25, 4-47

LC_COLLATE locale-file category 2-34, 2-35, 4-148, 4-200

LC_CTYPE locale-file category

alnum class 2-11, 4-89, 4-113

alpha class 2-11, 4-91, 4-116

blank class 2-12, 4-93, 4-117

cntrl class 2-12, 4-96, 4-119

description of 2-11

digit class 2-11, 4-98, 4-122

graph class 2-12, 4-99, 4-123

lower class 2-11, 4-102, 4-126

print class 2-12, 4-104, 4-127

punct class 2-12, 4-106, 4-130

space class 2-12, 4-108, 4-132

upper class 2-11, 4-110, 4-134

use in case conversion 2-15

use in character classification 2-13

xdigit class 2-11, 4-112, 4-136

LC_MONETARY locale-file category

currency_symbol subcategory 3-6, 4-37, 4-73

description of 3-5

int_curr_symbol subcategory 3-6, 4-37, 4-73

subcategories of 3-6

use in conversion 4-36, 4-38

use in formatting 4-72, 4-76

LC_NUMERIC locale-file category

description of 3-4

subcategories of 3-5

use in conversion 4-41, 4-44

use in formatting 4-78, 4-81

LC_TIME locale-file category

abday subcategory 3-8, 4-18, 4-27, 4-55, 4-63

abmon subcategory 3-8, 4-18, 4-27, 4-55, 4-63

alt_digits subcategory 3-8, 4-20, 4-29, 4-56, 4-65

am_pm subcategory 3-8, 4-28, 4-64

converting date values 4-22

converting date/time values 4-33

day subcategory 3-8, 4-18, 4-27, 4-55, 4-63

description of 3-7

d_fmt subcategory 3-8, 4-16, 4-19, 4-28, 4-54, 4-56, 4-65

d_t_fmt subcategory 3-8, 4-25, 4-27, 4-62, 4-63

era subcategory 3-8, 4-20, 4-30, 4-57, 4-66

era_d_fmt subcategory 3-8, 4-20, 4-30, 4-57, 4-66

era_d_t_fmt subcategory 3-8, 4-30, 4-66

era_t_fmt subcategory 3-8, 4-30, 4-66

formatting date values 4-59

formatting date/time values 4-69

mon subcategory 3-8, 4-18, 4-27, 4-55, 4-63

subcategories of 3-8

t_fmt subcategory 3-8, 4-28, 4-65

t_fmt_ampm subcategory 3-8, 4-28, 4-64

Length-terminated string 2-37

Locale 1-11

character classes 2-10

choosing 1-9

client 1-10, 1-11

code set. See Code set.

current 2-24

database 1-10, 1-11

default 1-11

definition of 1-9

determining maximum character size 2-40

effect on collation 4-148, 4-200

effect on date-string conversion 4-22

effect on date-string formatting 4-59

effect on date/time-string conversion 4-33

effect on date/time-string formatting 4-69

effect on money-string conversion 4-38

effect on money-string formatting 4-76

effect on number-string conversion 4-44

effect on number-string formatting 4-81

initializing 4-86

LC_COLLATE category 2-34

LC_CTYPE category 2-11

LC_MONETARY category 3-5

LC_NUMERIC category 3-4

LC_TIME category 3-7

localized collation order 2-34

maximum number of bytes in characters 4-139

name of 2-24, 4-13, 4-46, 4-50, 4-51

server 1-10, 1-11

server-processing 1-19

subdirectory for files 1-14, 1-23

U.S. English. See Default locale.

white space Intro-11

Localization 1-9

Localized collation order 2-34, 4-147, 4-199

Lower class 2-11, 2-13, 4-101, 4-125

Lowercase character

converting from uppercase 2-15, 4-185, 4-191

converting to uppercase 2-15, 4-188, 4-193

description of 2-11

testing for 2-13, 4-101, 4-125

LVARCHAR data type

See Character; Character string.

M

Machine notes Intro-14

Macro

IFX_GL_CASE_CONV_DST_BYTES 2-17, 4-186, 4-189

IFX_GL_CASE_CONV_SRC_BYTES 2-17, 4-186, 4-189

IFX_GL_MB_MAX 2-16, 2-23, 2-40

IFX_GL_PROC_CS 2-21, 2-22, 2-24, 4-13, 4-46, 4-50, 4-51

Major features Intro-4

Memory management

by INFORMIX-GLS library 1-22

case conversion 2-16, 2-23

code-set conversion 2-23

deallocating strings 2-42

fragmented string and 4-47

getting a multibyte character 4-84

INFORMIX-GLS functions for 4-5

multibyte-character strings and 2-40

wide character to multibyte character conversion 4-225

wide-character strings and 2-41

Message file

error messages Intro-13

location of 1-12

requirements 1-12

See also Error messages.

Microsoft 1252 code set 2-10

MI_SERVBUILD compiler flag 1-18

Monetary data

converting 4-35

currency symbol 3-6

decimal separator 3-6

field width 4-38, 4-75

format string 4-36, 4-72

formatting 4-71

formatting and conversion functions 4-10

formatting directives for 4-37, 4-73

grouping information 3-6, 4-38

international format 3-6, 4-37, 4-73

locale category for 3-5

locale-specific formats 3-5

national format 3-6, 4-37, 4-73

negative sign 3-6

positive sign 3-6

precision 4-75

SQL data types for 3-4

thousands separator 3-6, 4-74

MONETARY locale category. See LC_MONETARY locale-file category.

MONEY data type

See Monetary data.

Money string 3-5

Multibyte character

alphabetic 2-13, 4-90, 4-101, 4-109

alphabetic or digit 2-13, 4-88

blank character 2-13, 4-93

case conversion 2-15, 2-22, 4-185, 4-188

classifying 2-13

control character 2-13, 4-95

converting from wide character 2-9, 4-225

converting to wide character 2-9, 4-181

data type for 2-6

decimal digit 2-13, 4-97

definition of 2-5

description of 2-5

getting 1-22, 4-83

graphical character 2-13, 4-99

hexadecimal digit 2-13, 4-111

horizontal-space character 2-13, 4-93

inputting. See Multibyte character

getting.

locating in character string 2-33, 4-145, 4-174

lowercase character 2-13, 4-101

maximum size in bytes 2-40, 4-139

null byte in 2-6

null-terminated 2-38

number of bytes in 2-29, 4-140

outputting. See Multibyte character, putting.

passing to function 2-5

printable 2-13, 4-103

punctuation 2-13, 4-105

putting 1-22, 4-183

representation of Intro-10

splitting 2-42

stream I/O 1-22

termination of 2-38

uppercase character 2-13, 4-109

vertical-space character 2-13, 4-107

white-space character 2-13, 4-107

Multibyte-character string

buffer-size considerations 2-42

case conversion 2-18

comparing 2-35, 4-147

concatenation 2-31, 4-142, 4-159

converting to wide-character string 4-179

copying 2-32, 4-150

copying substring 4-162

data type for 2-6

fragmenting 2-43

functions for processing 2-31

keeping consistent 2-42

length of 2-32, 4-155

length without trailing space 2-32, 4-166, 4-168

length-terminated 2-37, 2-39, 2-43, 2-44

locating any character from substring 4-170

locating first occurrence of character in 2-33, 4-145

locating last occurrence of character in 2-33, 4-174

locating specific character in 2-33

locating substring in 2-33, 4-157

memory allocation 2-40

null terminator 2-6

null-terminated 2-37, 2-39, 2-41, 4-140

number of bytes in 2-32, 4-166

number of characters in 2-32, 4-155

number of characters without trailing space 2-32, 4-168

number of matching characters 2-33, 4-176

number of unmatched characters 2-33, 4-152

pointer to next character 2-29, 4-164

pointer to previous character 2-29, 4-172

sorting 2-35

string termination 2-37

traversing 2-29, 4-140

truncating 2-43

unfragmented 2-26

N

National currency format 3-6, 4-37, 4-73

NCHAR data type

See Character; Character string.

Negative sign 3-5, 3-6

Newline character

See also Vertical white space.

New-line character 2-12, 4-55, 4-64

Null character 2-6, 2-37

Null terminator 2-6, 2-41, 4-54, 4-62, 4-72, 4-78

Null-terminated string 2-38

Number string 3-4

Numeric data

base-4 representation 4-43, 4-79

binary representation 4-42, 4-79

converting 4-40

decimal separator 3-5

definition of 3-4, 3-5

field width 4-43, 4-81

floating-point representation 4-42, 4-79

format string 4-41, 4-78

formatting 4-77

formatting and conversion functions 4-10

formatting directives for 4-42, 4-79

grouping information 3-5

hexadecimal representation 4-43, 4-79

locale category for 3-4

locale-specific formats 3-4

negative sign 3-5

octal representation 4-42, 4-79

positive sign 3-5

precision 4-81

SQL data types for 3-4

thousands separator 3-5

unsigned decimal representation 4-43, 4-79

NUMERIC locale category. See LC_NUMERIC locale-file category.

Numeric-fill character. See Fill character.

NVARCHAR data type

See Character; Character string.

O

Optimizing. See Performance.

P

Percent symbol (%) 3-10

Performance

advancing pointer 4-140

case conversion 2-20

code-set conversion 2-28

improving 1-23

INFORMIX-GLS library optimization 1-23

wide-character processing 1-24

Platform icons Intro-8

Positive sign 3-5, 3-6

Precision

of date string 4-58

of date/time string 4-68

of money string 4-75

of number string 4-81

Print class 2-12, 2-13, 4-103, 4-127

Printable character 2-12, 2-13, 4-103, 4-127

Printed manuals Intro-13

Punct class 2-12, 2-13, 4-105, 4-129

Punctuation character 2-12, 2-13, 4-105, 4-129

R

Radix character. See Decimal separator.

Related reading Intro-14

Release notes Intro-14

Resource file 1-12

Return values. See individual function names.

S

Server locale 1-10, 1-11, 1-19

Server-processing locale 1-10, 1-11, 1-19

SERVER_LOCALE environment variable 1-11

Single-byte character

description of 2-4

forward traversal of 2-29, 4-164

in code-set conversion 4-51

representation of Intro-9

reverse traversal of 4-172

SMALLFLOAT data type

See Numeric data.

SMALLINT data type

See Numeric data.

Software dependencies Intro-4

Sort order. See Collation.

Space character. See Blank character; White-space character.

Space class 2-12, 2-13, 4-28, 4-107, 4-131

Stream input 1-22

Stream output 1-22

String operations 2-29

See also String processing; String traversal.

String processing

character searching 2-33

concatenation 2-31

INFORMIX-GLS functions for 2-31

multibyte characters 2-31

string copying 2-32

string-length determination 2-32

wide characters 2-31

String traversal 2-29

String. See Character string; Multibyte-character string; Wide-character string.

Structure

conv_state_t 2-25, 4-47

gl_wchar_t 2-8

T

Tab character 2-12, 4-56, 4-64

See also Horizontal white space.

Thousands separator 3-5, 3-6, 4-74, 4-75

Thread-safe application 1-21

Time data. See Date/time data.

TIME locale category. See LC_TIME locale-file category.

Trailing white space

including in length of multibyte-character string 4-155

including in length of wide-character string 4-206

omitting from length of multibyte string 4-166, 4-168

omitting from length of wide-character string 4-212

representation of Intro-11

Type specifier

definition of 3-10

for converting date strings 4-18

for converting date/time strings 4-27

for converting money strings 4-37

for converting number strings 4-42

for formatting date strings 4-55

for formatting date/time strings 4-63

for formatting money strings 4-73

for formatting number strings 4-79

See also Formatting directive.

U

UDR. See DataBlade UDR.

UNIX environment

default code set 2-10

Upper class 2-11, 2-13, 4-109, 4-133

Uppercase character

converting from lowercase 2-15, 4-188, 4-193

converting to lowercase 2-15, 4-185, 4-191

description of 2-11

testing for 2-13, 4-109, 4-133

User-defined routine. See DataBlade UDR.

V

VARCHAR data type

See Character; Character string.

Vertical white space 2-12, 2-13, 4-107, 4-131

Vertical-tab character 2-12

See also Vertical white space.

W

White-space character

horizontal or vertical white space 2-12

horizontal white space 2-12

See also Horizontal white space; Vertical white space.

Wide character

alphabetic 2-13, 4-115, 4-125, 4-133

alphabetic or digit 2-13, 4-113

assigning value to 2-9

blank character 2-13, 4-117

case conversion 2-19, 4-191, 4-193

classifying 2-13

comparing 2-9

control character 2-13, 4-119

converting from multibyte character 2-9, 4-181

converting to multibyte character 2-9, 4-225

data type for 2-8

decimal digit 2-13, 4-121

definition of 2-7

description of 2-7

graphical character 2-13, 4-123

hexadecimal digit 2-13, 4-135

horizontal-space character 2-13, 4-117

locating in character string 2-33, 4-197, 4-216

lowercase character 2-13, 4-125

printable 2-13, 4-127

processing of 1-24

punctuation 2-13, 4-129

uppercase character 2-13, 4-133

vertical-space character 2-13, 4-131

white-space character 2-13, 4-131

Wide-character string

comparing 2-35, 4-199

concatenation 2-31, 4-195, 4-208

converting to multibyte-character string 4-221

copying 2-32, 4-201

copying substring 4-210

data type for 2-8

functions for processing 2-31

length 2-30, 4-206

length of 2-32

length without trailing space 2-32, 4-212

length-terminated 2-37

locating any character from substring 4-214

locating first occurrence of character in 2-33, 4-197

locating last occurrence of character in 2-33, 4-216

locating specific character in 2-33

locating substring in 2-33, 4-223

memory allocation 2-41

null-terminated 2-37, 2-42

number of characters in 2-30, 2-32, 4-206

number of characters without trailing space 2-32, 4-212

number of matching characters 2-33, 4-218

number of unmatched characters 2-33, 4-203

sorting 2-35

string termination 2-37

traversing 2-30

Windows environments

default code set 2-10

X

Xdigit class 2-11, 2-13, 4-111, 4-135

X/Open XPG4 internationalization standards 1-8

X/Open, differences from 1-8

Symbols

%, percent sign. See Conversion specifications.