Sybase 12.4.2 Manuale Utente
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 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
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
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
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
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
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
RESOURCE authority overview ............................................ 355
Ownership permissions overview .......................................... 355
Table and views permissions overview ................................. 355
Group permissions overview ................................................. 356