blogspot.com-GA4

星期六, 5月 10, 2008

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





這樣才完成

沒有留言: