Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

load flatfiles with bcp in SQLServer

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
krisvangool
Asked:
krisvangool
  • 2
1 Solution
 
tchalkovCommented:
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
 
krisvangoolAuthor Commented:
Thank you for answering but ...

Where/how can I find/check/change the character set definitions of SQLServer ?
0
 
Victor SpiridonovCommented:
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
 
tchalkovCommented:
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now