krisvangool
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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
ASKER
Where/how can I find/check/change the character set definitions of SQLServer ?