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.  
krisvangoolAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
tchalkovConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.