Changing Collations

[Mike C#]

Hi all,

I have a strange little issue. I need to load some data from VC++ into SQL
Server but I need to "map" (for lack of a better word) some of the strings
to a different collation. Is there a VC++ function to convert strings from
one collation to another? And would anyone know if Windows collations are
compatible with SQL Server collations?

Thanks

 

[Mike C#]

It looks like ::WideCharToMultiByte will do the trick. Thanks.

 

[Mike C#]

Correction, make that ::MultiByteToWideChar. Thanks.