Sybase資料庫初始化設定

來源：Sybase資料庫初始化設定

由於sybase在台灣的設定資料還真的蠻難找的，底下的設定是預設的初始設定，有些是必須要視情況修訂的，可別照抄咧。

sp_configure "max memory",870400

sp_cacheconfig "default data cache","1024M"

sp_configure "number of open objects",5000

sp_configure "number of open indexes",15000

sp_configure "max online engines",1

sp_configure "number of engines at startup", 1

sp_configure "number of locks",65535

sp_addserver "SYB_BACKUP",null,"JACK_BS"

sp_configure "procedure cache size", 51200

sp_configure 'max network packet size',4096

sp_configure 'number of user connections',100

另外若要改資料庫為big語系步驟為

1. cd\sybase\charsets\big5



2. charset -Usa -P1234 -Sjack binary.srt big5



3. 接著用 SQL Advantage

sp_configure "default character set id",161

go

4. 用文書編輯器修改 C:\sybase\locales\locales.dat

引用

[NT]

locale = enu, us_english, iso_1

locale = fra, french, iso_1

locale = deu, german, iso_1

locale = rus, russian, cp1251

locale = hun, us_english, cp1250

locale = ell, us_english, cp1253

locale = heb, us_english, cp1255

locale = ara, us_english, cp1256

locale = trk, us_english, cp1254

locale = esp, spanish, iso_1

locale = jpn, japanese, sjis

locale = japanese, japanese, sjis

locale = chs, chinese, eucgb

locale = cht, tchinese, big5

locale = kor, korean, cp949

locale = us_english.utf8, us_english, utf8

;locale = default, us_english, iso_1

locale = default,us_english, big5

這樣才完成