Solved

load flatfiles with bcp in SQLServer

Posted on 1998-11-20
4
238 Views
Last Modified: 2010-03-19
SQLServer 6.5, NT Server 4.

I try to load a flatfile into a sqlserver table with a bcp-command. It works. But I have one problem: all my ASCII characters > 128 (e.g. à, ï, é...) are wrong converted (e.g. à (133) becomes n, ...) Does anyone knows a solution.  
0
Comment
Question by:krisvangool
  • 2
4 Comments
 
LVL 7

Accepted Solution

by:
tchalkov earned 100 total points
Comment Utility
this usually happens when the character set of sql server is different from tha character set of your file. so check the character set of the sql server. have in mind that if you change the character set you must rebuild the master database which means that you must recreate all databases that you have currently
0
 

Author Comment

by:krisvangool
Comment Utility
Thank you for answering but ...

Where/how can I find/check/change the character set definitions of SQLServer ?
0
 
LVL 7

Expert Comment

by:spiridonov
Comment Utility
You can check it by executing sp_configure stored procedure, however you can't change it. In order to have a different character set you will have to reinstall SQL server.
0
 
LVL 7

Expert Comment

by:tchalkov
Comment Utility
you can change it using sql server setup - there is no need to reinstall it but the effect will be the same - you will lose all databases
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now