Character Translation Problem!!!

Character Translation Problem!!!

Post by Jibril A. GUEY » Tue, 17 Nov 1998 04:00:00



Hi 2 All,

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
------------------------------------------------------------------

  ~   ? | ? a ? ? - ? 2 3 ? ? 1 o ? ? ? ?
  ? 0 1 2 3 4 5 6 7 8 9 A=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 Y=y ? Z=z D=e T=t.

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"

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

 
 
 

1. character translation problem

Hi 2 All,

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
------------------------------------------------------------------

  ~   ? | ? a ? ? - ? 2 3 ? ? 1 o ? ? ? ?
  ? 0 1 2 3 4 5 6 7 8 9 A=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 Y=y ? Z=z D=e T=t.

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"

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

2. Looking for Programers

3. SQL / ASP Extended character translation problems

4. idc/htx

5. Character translation problem with string ID generator

6. problem with Win95 client

7. ODBC character translation

8. get text of stored procedures and views

9. Automatic character translation in .NET Provider

10. ODBC character translation (OEM to ANSI)

11. Automatic Character Translation in .NET Provider

12. Translation for character

13. Character translation