Contents

 

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

xi

Page 11
Image 11
Sybase 12.4.2 manual 323, 339, 352, Managing User IDs and Permissions