Гость
Форумы
[новые:0]
/ Sybase ASA, ASE, IQ
[новые:0]
[игнор отключен]
[закрыт для гостей]
/
SyBase ASE 12/5/2 Cannot reconfigure server to use sort order
[новые:0]
8 сообщений из 8, страница 1 из 1
|
|
|
SyBase ASE 12/5/2 Cannot reconfigure server to use sort order
|
|||
|---|---|---|---|
|
#18+
ASE 12.5.2 под Windows. При попытке изменить в SyBase Central "default charachter set id" c 2 на 53 и "default sortorder id" с 50 на 59 выводится сообшение "Cannot reconfigure server to use sort order ID 50, because the row for its underlying character set (id 53) not exist in syscharsets." CharSet -U - P -S .....binary.srt cp1251 и CharSet -U -P -S ....Rusnocs.srt cp1251 были успешно установлены. Как поменять данные настройки? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 14.09.2004, 16:21 |
|
||
|
SyBase ASE 12/5/2 Cannot reconfigure server to use sort order
|
|||
|---|---|---|---|
|
#18+
select * from master..syscharsets сделай ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 14.09.2004, 17:02 |
|
||
|
SyBase ASE 12/5/2 Cannot reconfigure server to use sort order
|
|||
|---|---|---|---|
|
#18+
MasterZivselect * from master..syscharsets сделай type id csid status name description definition sortfile ------ --- ---- ------ ------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------ 1001 0 0 0 ascii_8 ASCII, for use with unspecified 8-bit data. 0x000008000101080002020800030308000404080005050800060608000707080008080800090908 080a0a08080b0b08080c0c08080d0d08080e0e08080f0f0808101008001111080012120800131308 001414080015150800161608001717080018180800191908001a1a08001b1b08001c1c08001d1d08 001e1e08001f1f080020200808212120202222102023230120242440202525202026262020272710 2028282020292920202a2a20202b2b20202c2c20202d2d20202e2e20202f2f202030300214313102 1432320214333302143434021435350214363602143737021438380214393902143a3a20203b3b20 203c3c20203d3d20203e3e20203f3f20204040012041610111426201114363011144640111456501 11466601114767010148680101496901014a6a01014b6b01014c6c01014d6d01014e6e01014f6f01 01507001015171010152720101537301015474010155750101567601015777010158780101597901 015a7a01015b5b20205c5c20205d5d20205e5e20205f5f0120606020204161011242620112436301 124464011245650112466601124767010248680102496901024a6a01024b6b01024c6c01024d6d01 024e6e01024f6f010250700102517101025272010253730102547401025575010256760102577701 0258780102597901025a7a01027b7b20207c7c20207d7d20207e7e20207f7f200080800102818101 0282820102838301028484010285850102868601028787010288880102898901028a8a01028b8b01 028c8c01028d8d01028e8e01028f8f01029090010291910102929201029393010294940102959501 02969601029797010298980102999901029a9a01029b9b01029c9c01029d9d01029e9e01029f9f01 02a0a00102a1a10102a2a20102a3a30102a4a40102a5a50102a6a60102a7a70102a8a80102a9a901 02aaaa0102abab0102acac0102adad0102aeae0102afaf0102b0b00102b1b10102b2b20102b3b301 02b4b40102b5b50102b6b60102b7b70102b8b80102b9b90102baba0102bbbb0102bcbc0102bdbd01 02bebe0102bfbf0102c0c00102c1c10102c2c20102c3c30102c4c40102c5c50102c6c60102c7c701 02c8c80102c9c90102caca0102cbcb0102cccc0102cdcd0102cece0102cfcf0102d0d00102d1d101 02d2d20102d3d30102d4d40102d5d50102d6d60102d7d70102d8d80102d9d90102dada0102dbdb01 02dcdc0102dddd0102dede0102dfdf0102e0e00102e1e10102e2e20102e3e30102e4e40102e5e501 02e6e60102e7e70102e8e80102e9e90102eaea0102ebeb0102ecec0102eded0102eeee0102efef01 02f0f00102f1f10102f2f20102f3f30102f4f40102f5f50102f6f60102f7f70102f8f80102f9f901 02fafa0102fbfb0102fcfc0102fdfd0102fefe0102ffff0102000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000003031323330313230303232343535303132363233303130323032 00000000000030313233303132303032323435353031323632333031303230320000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 000000000000 NULL 1001 1 0 0 iso_1 ISO 8859-1 (Latin-1) - Western European 8-bit character set. 0x000008000101080002020800030308000404080005050800060608000707080008080800090908 080a0a08080b0b08080c0c08080d0d08080e0e08080f0f0808101008001111080012120800131308 001414080015150800161608001717080018180800191908001a1a08001b1b08001c1c08001d1d08 001e1e08001f1f080020200808212120202222102023230120242440202525202026262020272710 2028282020292920202a2a20202b2b20202c2c20202d2d20202e2e20202f2f202030300214313102 1432320214333302143434021435350214363602143737021438380214393902143a3a20203b3b20 203c3c20203d3d20203e3e20203f3f20204040012041610111426201114363011144640111456501 11466601114767010148680101496901014a6a01014b6b01014c6c01014d6d01014e6e01014f6f01 01507001015171010152720101537301015474010155750101567601015777010158780101597901 015a7a01015b5b20205c5c20205d5d20205e5e20205f5f0120606020204161011242620112436301 124464011245650112466601124767010248680102496901024a6a01024b6b01024c6c01024d6d01 024e6e01024f6f010250700102517101025272010253730102547401025575010256760102577701 0258780102597901025a7a01027b7b20207c7c20207d7d20207e7e20207f7f200080800100818101 0082820100838301008484010085850100868601008787010088880100898901008a8a01008b8b01 008c8c01008d8d01008e8e01088f8f01089090010091910100929201009393010094940100959501 00969601009797010098980100999901009a9a01009b9b01009c9c01009d9d01009e9e01009f9f01 00a0a00108a1a10120a2a20120a3a34020a4a44020a5a54020a6a60120a7a70120a8a80120a9a901 20aaaa0120abab0120acac0120adad0108aeae0120afaf0120b0b00120b1b10120b2b20120b3b301 20b4b40120b5b50120b6b60120b7b70120b8b80120b9b90120baba0120bbbb0120bcbc0120bdbd01 20bebe0120bfbf0120c0e00101c1e10101c2e20101c3e30101c4e40101c5e50101c6e60101c7e701 01c8e80101c9e90101caea0101cbeb0101ccec0101cded0101ceee0101cfef0101d0f00101d1f101 01d2f20101d3f30101d4f40101d5f50101d6f60101d7d70120d8f80101d9f90101dafa0101dbfb01 01dcfc0101ddfd0101defe0101dfdf0101c0e00102c1e10102c2e20102c3e30102c4e40102c5e501 02c6e60102c7e70102c8e80102c9e90102caea0102cbeb0102ccec0102cded0102ceee0102cfef01 02d0f00102d1f10102d2f20102d3f30102d4f40102d5f50102d6f60102f7f70120d8f80102d9f901 02dafa0102dbfb0102dcfc0102ddfd0102defe0102ffff0102000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000003031323330313230303232343535303132363233303130323032 00000000000030313233303132303032323435353031323632333031303230320000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000030303030303030303030303030303030303030 30303030003030303030303030303030303030303030303030303030303030303030303000303030 303030303000 NULL 1001 2 0 0 cp850 Code Page 850 (Multilingual) character set. 0x000008000101202002022020030320200404202005052020060620200707082008080820090908 080a0a08080b0b08080c0c08080d0d08080e0e20200f0f2020101020201111202012122020131320 201414012015150120161620201717202018182020191920201a1a20201b1b20201c1c08201d1d20 201e1e20201f1f202020200808212120202222102023230120242440202525202026262020272710 2028282020292920202a2a20202b2b20202c2c20202d2d20202e2e20202f2f202030300214313102 1432320214333302143434021435350214363602143737021438380214393902143a3a20203b3b20 203c3c20203d3d20203e3e20203f3f20204040012041610111426201114363011144640111456501 11466601114767010148680101496901014a6a01014b6b01014c6c01014d6d01014e6e01014f6f01 01507001015171010152720101537301015474010155750101567601015777010158780101597901 015a7a01015b5b20205c5c20205d5d20205e5e20205f5f0120606020204161011242620112436301 124464011245650112466601124767010248680102496901024a6a01024b6b01024c6c01024d6d01 024e6e01024f6f010250700102517101025272010253730102547401025575010256760102577701 0258780102597901025a7a01027b7b20207c7c20207d7d20207e7e20207f7f2008808701019a8101 0290820102b68301028e840102b78501028f86010280870102d2880102d3890102d48a0102d88b01 02d78c0102de8d01028e8401018f860101908201019291010292910101e293010299940102e39501 02ea960102eb97010259980102999401019a8101019d9b01029c9c40209d9b01019e9e20209f9f20 20b5a00102d6a10102e0a20102e9a30102a5a40102a5a40101a6a62020a7a72020a8a82020a9a920 20aaaa2020abab2020acac2020adad2020aeae2020afaf2020b0b02020b1b12020b2b22020b3b320 20b4b42020b5a00101b6830101b7850101b8b82020b9b92020baba2020bbbb2020bcbc2020bdbd20 20bebe4020bfbf2020c0c02020c1c12020c2c22020c3c32020c4c42020c5c52020c7c60102c7c601 01c8c82020c9c92020caca2020cbcb2020cccc2020cdcd2020cece2020cfcf4020d1d00102d1d001 01d2880101d3890101d48a010149d50102d6a10101d78c0101d88b0101d9d92020dada2020dbdb20 20dcdc2020dddd2020de8d0101dfdf2020e0a20101e1e10102e2930101e3950101e5e40102e5e401 01e6e60102e8e70102e8e70101e9a30101ea960101eb970101edec0102edec0101eeee0120efef01 20f0f02020f1f12020f2f22020f3f32020f4f40120f5f50120f6f62020f7f70120f8f80120f9f901 20fafa0120fbfb2020fcfc2020fdfd2020fefe2020ffff0808000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000003031323330313230303232343535303132363233303130323032 00000000000030313233303132303032323435353031323632333031303230320000000000303030 30303030303030303030303030303030303030303030303030003000003030303030300000000000 00000000000000000000303030000000000000000000000000000030300000000000000000303030 30303030303000000000003000300030303030003030303030303000000000000000000000000000 000000000000 NULL 2003 20 190 0 defaultml Default Unicode multi-lingual ordering NULL NULL 2003 21 190 0 thaidict Thai dictionary ordering NULL NULL 2003 22 190 0 iso14651 Ordering as per ISO14651 standard NULL NULL 2003 24 190 0 utf8bin Ordering for UTF-16 that matches the binary ordering of UTF-8 NULL NULL 2003 25 190 0 binary Binary ordering for UTF-16 NULL NULL 2003 39 190 0 altnoacc Alternate (lower-case first) accent-insensitive dictionary ordering NULL NULL 2003 45 190 0 altdict Alternate (lower-case first) dictionary ordering NULL NULL 2003 46 190 0 altnocsp Alternate (lower-case first) case-insensitive dictionary ordering with order-by preference NULL NULL 2003 47 190 0 scandict Scandinavian dictionary ordering NULL NULL 2003 48 190 0 scannocp Scandinavian case-insensitive dictionary ordering with order-by prefere nce NULL NULL 2001 50 1 0 bin_iso_1 Binary ordering, for the ISO 8859/1 or Latin-1 character set (iso_1). 0x0000 binary.srt 2001 50 2 0 bin_cp850 Binary ordering, for use with Code Page 850 (cp850). 0x0000 binary.srt 2003 51 190 0 dict General-purpose dictionary ordering NULL NULL 2003 52 190 0 nocase General-purpose case-insensitve dictionary ordering NULL NULL 2003 53 190 0 nocasep General-purpose case-insensitve dictionary ordering with order-by prefe rence NULL NULL 2003 54 190 0 noaccent General-purpose accent-insensitive dictionary ordering NULL NULL 2003 55 190 0 espdict Spanish dictionary ordering NULL NULL 2003 56 190 0 espnocs Spanish case-insensitive dictionary ordering NULL NULL 2003 57 190 0 espnoac Spanish accent-insenitive dictionary ordering NULL NULL 2003 59 190 0 rusnocs Russian case-insensitive dictionary ordering NULL NULL 2003 64 190 0 cyrnocs Common cyrillic case-insensitive dictionary ordering NULL NULL 2003 65 190 0 elldict Greek dictionary ordering NULL NULL 2003 69 190 0 hundict Hungarian dictionary ordering NULL NULL 2003 70 190 0 hunnoac Hungarian accent-insensitive dictionary ordering NULL NULL 2003 71 190 0 hunnocs Hungarian case-insensitive dictionary ordering NULL NULL 2003 73 190 0 turknoac Turkish accent-insensitive dictionary ordering NULL NULL 2003 74 190 0 turknocs Turkish case-insensitive dictionary ordering NULL NULL 2004 129 190 0 cp932bin Ordering that matches the binary ordering of the cp932 character set NULL cp932bin.ust 2004 130 190 0 dynix Chinese phonetic ordering NULL dynix.ust 2004 137 190 0 gb2312bn Ordering that matches the binary ordering of the gb2312 character set NULL gb2312bn.ust 2004 140 190 0 cyrdict Common cyrillic dictionary ordering NULL cyrdict.ust 2004 155 190 0 turdict Turkish dictionary ordering NULL turdict.ust 2004 161 190 0 euckscbn Ordering that matches the binary ordering of the EUCKSC character set NULL euckscbn.ust 2004 163 190 0 gbpinyin Chinese phonetic ordering NULL gbpinyin.ust 2004 165 190 0 rusdict Russian dictionary ordering NULL rusdict.ust 2004 179 190 0 sjisbin Ordering that matches the binary ordering of the SJIS character set NULL sjisbin.ust 2004 192 190 0 eucjisbn Ordering that matches the binary ordering of the EUCJIS character set NULL eucjisbn.ust 2004 194 190 0 big5bin Ordering that matches the binary ordering of the big5 character set NULL big5bin.ust (41 rows affected) Это выдал селект. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 14.09.2004, 17:42 |
|
||
|
SyBase ASE 12/5/2 Cannot reconfigure server to use sort order
|
|||
|---|---|---|---|
|
#18+
если ничего не путаю, сначала надо с консоли командой charset вставить эти кодировки вот пример для koi8 и sortorder case-sensitive charset -Usa -Ppassword -SMYSERVER rusdict.srt koi8 charset -Usa -Ppassword -SMYSERVER binary.srt koi8 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 14.09.2004, 18:22 |
|
||
|
SyBase ASE 12/5/2 Cannot reconfigure server to use sort order
|
|||
|---|---|---|---|
|
#18+
Их есть у меняесли ничего не путаю, сначала надо с консоли командой charset вставить эти кодировки вот пример для koi8 и sortorder case-sensitive charset -Usa -Ppassword -SMYSERVER rusdict.srt koi8 charset -Usa -Ppassword -SMYSERVER binary.srt koi8 CharSet -U - P -S .....binary.srt cp1251 и CharSet -U -P -S ....Rusnocs.srt cp1251 были уже выполнены до того как я начал менять default'ы ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 14.09.2004, 18:37 |
|
||
|
SyBase ASE 12/5/2 Cannot reconfigure server to use sort order
|
|||
|---|---|---|---|
|
#18+
Блин, не знаю. Вроде бы есть этот 50-ий sort order и 53-ий char set. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 16.09.2004, 10:36 |
|
||
|
SyBase ASE 12/5/2 Cannot reconfigure server to use sort order
|
|||
|---|---|---|---|
|
#18+
Если не ошибаюсь CharSet -U - P -S .....binary.srt cp1251 добавляет такую строку type id csid status name ----------- ----------- ----------- ----------- ---- 2001 50 53 0 bin_cp1251 и т.д. что-то я ее не заметил, вобще имен типа %cp1251 не видно. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 16.09.2004, 11:15 |
|
||
8 сообщений из 8, страница 1 из 1
|
|
Форумы
[новые:0]
/ Sybase ASA, ASE, IQ
[новые:0]
[игнор отключен]
[закрыт для гостей]
/
SyBase ASE 12/5/2 Cannot reconfigure server to use sort order
[новые:0]
