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

Thread View: comp.databases.ms-sqlserver

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Jeff Tulley Wed, 08 Apr 1998 00:00

#148

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

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

#149

Author: Richard Waymire
Date: Wed, 08 Apr 1998 00:00

31 lines
1846 bytes

Have you got the "automatic ansi to oem conversion" and "use international
settings" checked? You might want to look into this...

--
Richard Waymire, MCT, MCSE+Internet, MCSD, MVP (SQLServer)
Senior Principal Instructor/Consultant, ARIS Corp.
President, Pacific NW SQLServer Users Group (http://www.pnwssug.org)
Visit us at http://www.aris.com

Jeff Tulley wrote in message <01bd62d2$fada32e0$010a0080@enterprise>...
>
>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
>

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

#150

Author: Ron Talmage
Date: Wed, 08 Apr 1998 00:00

32 lines
1601 bytes

Jeff,

Does the character set of SQL Server match the character set of the
Portugese NT? It sounds like one of the two may be ANSI.

Ron


On Wed, 8 Apr 1998 04:42:21 -0500 , "Jeff Tulley"
<jeff@matrix-pubs.co.uk> wrote:

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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads