Advice required with BCP Characters being converted to ANSI on import to DB

Article View: comp.databases.ms-sqlserver

Article #148

Back to comp.databases.ms-sqlserver Previous Next

#148

From: Jeff Tulley
Date: Wed, 08 Apr 1998 00:00

20 lines
1353 bytes


We have a client in Portugal who is running a dataload that uses BCP.  All
of their Portuguese characters are being written to the database as ANSI
characters.  Does anyone have any ideas as to why this would happen and
what we could do to prevent it.


Please post your replies to the NG for the benefit of all to see


Kind regards

Jeff Tulley

MATRIX Publishing Systems
Nottingham
England

jeff@matrix-pubs.co.uk

Technical Details

Message-ID: <01bd62d2$fada32e0$010a0080@enterprise>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f816f,33320f1cb3420d7d,start
X-Google-Attributes: gidf816f,public
X-Google-Thread: 10f695,33320f1cb3420d7d,start
X-Google-Attributes: gid10f695,public
X-Google-Thread: 106afd,33320f1cb3420d7d,start
X-Google-Attributes: gid106afd,public
X-Google-Thread: ff490,33320f1cb3420d7d,start
X-Google-Attributes: gidff490,public
X-Google-Thread: 104de1,33320f1cb3420d7d,start
X-Google-Attributes: gid104de1,public
From: "Jeff Tulley" <jeff@matrix-pubs.co.uk>
Subject: Advice required with BCP Characters being converted to ANSI on import to DB
Date: 1998/04/08
Message-ID: <01bd62d2$fada32e0$010a0080@enterprise>
X-Deja-AN: 342008087
Keywords: BCP ANSI OEM CONVERSION
Organization: MATRIX
Newsgroups: comp.databases.ms-sqlserver,cz.comp.microsoft.sql,microsoft.public.de.sqlserver,microsoft.public.sqlserver.misc,microsoft.public.sqlserver.server