Bonjour,
Je voudrais faire un load d'une base source en version 11.9.2.4 avec les carateristiques :
Sort Order Description
------------------------------------------------------------------
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 53, nocasepref_iso_1
Case-insensitive dictionary sort order, with case preference f
or collating purposes, for use with several Western-European l
anguages including English, French, and German. Uses the ISO
8859-1 character set.
Characters, in Order
et la base cible avec les carateristiques ci-dessous:
Sort Order Description
------------------------------------------------------------------
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 50, bin_iso_1
Binary ordering, for the ISO 8859/1 or Latin-1 character set (
iso_1).
Characters, in Order
en lançant la commande de load sur la base cible, j'ai le message d'erreur suivant:
Msg 3120, Level 16, State 1:
Server 'MU_SV_TPBI', Line 1:
The database you are attempting to LOAD was DUMPed under a different sort order
ID (53) or character set ID (1) than the ones running on this server (SortOrd =
50, CharSet = 1). If the sort orders differ, at least one of them is
non-binary.
Comment puis-je faire pour resoudre ce problème ?
est ce que je peux executer la commande suivante sur la base cible:
charset -Usa -P... -S ... nocasepref_iso_1 iso_1 et faire
sp_configure "default sortorder id",53
?
Merci de vos conseils ?
Partager