character translation problem
Jibril A. GUEYE
I have a serious character translation problem!
I have 4 SQL Server configure identically. Here is a sample of
the output of the execution of: sp_helpsort
Sort Order Description
------------------------------------------------------------------
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 52, nocase
Case-insensitive dictionary sort order for use with several We
stern-European languages including English, French, and German
. Uses the ISO 8859-1 character set.
Characters, in Order
------------------------------------------------------------------
! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | }
~ ¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ® ¯ ° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾
¿ × ÷ 0 1 2 3 4 5 6 7 8 9 A=a À=à Á=á Â=â Ã=ã Ä=ä Å=å Æ=æ B=b C
=c Ç=ç D=d E=e È=è É=é Ê=ê Ë=ë F=f G=g H=h I=i Ì=ì Í=í Î=î Ï=ï J
=j K=k L=l M=m N=n Ñ=ñ O=o Ò=ò Ó=ó Ô=ô Õ=õ Ö=ö Ø=ø P=p Q=q R=r S
=s ß T=t U=u Ù=ù Ú=ú Û=û Ü=ü V=v W=w X=x Y=y Ý=ý ÿ Z=z Ð=ð Þ=þ.
The problem arise when i tryin to do a db transfer between servers.
The accentued characters get misrepresented!!!
Any solution to this problem would be greatly appreciated.
Aziz
Motto: "Smalltalk 4 Ever"
Analyst / Programer @ MARQUE D'OR
Smalltalk [All flavors], MS-SQL
Web Page: http://members.tripod.com/~jgueye
Tel(s):
- Home: 514.935.7376
- Office: 514.393.9901 Ext. 368
Fax: 514.393.4060