Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 11 / 536

Contents
xi
Understanding locales.................................................................. 323
Introduction to locales ........................................................... 323
Understanding the locale language....................................... 324
Understanding the locale character set................................. 325
Understanding the locale collation label ................................ 328
Setting the SQLLOCALE environment variable .................... 328
Understanding collations .............................................................. 328
Displaying collations .............................................................. 328
Supplied collations ................................................................ 329
ANSI or OEM?....................................................................... 331
Notes on ANSI collations....................................................... 332
Notes on OEM collations ....................................................... 334
Using multibyte collations ...................................................... 336
Understanding character set translation ...................................... 336
Character translation for database messages....................... 336
Connection strings and character sets .................................. 338
Avoiding character-set translation ......................................... 338
Collation internals......................................................................... 339
Comment lines ...................................................................... 340
The title line ........................................................................... 340
The collation sequence section ............................................. 341
The Encodings section .......................................................... 342
The Properties section .......................................................... 343
International language and character set tasks ........................... 344
Finding the default collation................................................... 344
Configuring your character set environment ......................... 344
Determining locale information.............................................. 345
Setting locales ....................................................................... 346
Creating a database with a named collation ......................... 346
Starting a database server using character set translation ... 348
Using ODBC code page translation ...................................... 348
Character set translation for Sybase Central and DBISQL ... 349
Creating a custom collation ................................................... 349
Creating a database with a custom collation ......................... 351
Compatibility issues ..................................................................... 351
Performance issues ..................................................................... 352
CHAPTER 10 Managing User IDs and Permissions ........................................ 353
An overview of database permissions.......................................... 353
DBA authority overview ......................................................... 354
RESOURCE authority overview ............................................ 355
Ownership permissions overview .......................................... 355
Table and views permissions overview ................................. 355
Group permissions overview ................................................. 356