Cool. Especially the way to automate BCP. Very useful as a backup tool.

However, I have a problem  with this bcp feature itself : I have a database which holds many French words, spelled with the nice é, è, ê, û aso characters.

When I bcp them out, and then re-bcp them in, they are converted to silly other things , due to the non-unicode-compliance of wordpad flat text documents . Any idea how I could conserve the code page stored in nvarchar fields, in a bcp file?

Maybe, a pro like you guys knows an answer here ?