Very Computer

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. Too few parameters - parameters not being used in parameter query?

3. code page translations problem..!

4. DTSRUN utility - how does it work?

5. Translation Problem

6. Cubes

7. character translation problem

8. VFP Editor Tools

9. Problem with translation dll

10. SQL / ASP Extended character translation problems

11. Driver Translation Problem SQL 6.5

12. Character translation problem with string ID generator

13. DTS Date Translation Problem