1
Vote

Crash when changing codepage for bcp

description

I have the problem that Euro currency Symbol (€) contained in a varchar column in one of my tables gets converted to underscore (_) when using SQL Azure Migration Wizzard.
So I changed the codepage from 437 to 1252 and the application keep crashing as soon as the first table of my db is processed.

file attachments

comments

ghuey wrote Oct 13, 2010 at 9:36 PM

Hi Frank,

Sorry, but I totally forgot about the Issue Tracker and thus didn't see this. Did you ever get this resolved?

Thanks,
George

frank83 wrote Oct 14, 2010 at 7:16 AM

Hey George,

I just reported it, didn't try to fix this myself.

Regards, Frank

ghuey wrote Oct 14, 2010 at 2:09 PM

Can you create a very simple database with a couple of tables that reproduce the problem? You can do a backup and send me the bak file? You still have my email address?

Thanks,
George

frank83 wrote Oct 14, 2010 at 3:53 PM

No, I don't have your email address...
Please find the db backup attached to this post!
First, you need to setup the bcp codepage to 1252 in the xml-config file of sqlazuremw.