Hello

I'm trying to load a database that it came from a different sort order
id. Originally I was getting the following error message

Msg 3120, Level 16, State 1:
Line 2:
The database you are attempting to LOAD was Dumped under a different
sort order
ID (52) or character set ID (1) than the ones running on this server
(Sorter =
49, CharSet = 2). If the sort orders differ, at least one of them is
non-binary.


then I changed the sortorder id to
sp_configure 'default sortorder id', 52, 'utf8'

but I made a mistake with the 'utf8'
Now I'm getting this error message


Msg 3120, Level 16, State 1:
Line 1:
The database you are attempting to LOAD was DUMPed under a different
sort order
ID (52) or character set ID (1) than the ones running on this server
(SortOrd =
52, CharSet = 190). If the sort orders differ, at least one of them is
non-binar
y.
1>


Sort Order Description

------------------------------------------------------------------
Character Set = 190, utf8
Unicode 3.1 UTF-8 Character Set
Class 2 Character Set
Sort Order = 52, nocase
General-purpose case-insensitve dictionary ordering
(return status = 0)
1>


1> sp_configure 'default character set', 1
2> go
Msg 5824, Level 16, State 4:
Procedure 'sp_configure', Line 695:
Cannot reconfigure server to use sort order ID 52, because the row for
its under
lying character set (ID 1) does not exist in syscharsets.
(return status = 1)


How can I change the default character set from = 190 TO 1 ?

Thanks
Maria

Have you tried the sqlloc program found in the ASE../bin directory?
"Maria" <evoradba (AT) yahoo (DOT) ca> wrote