hi,

i have a system that is using sql server 2000 and it imports data to another system that is oracle

we have international characters from all different countries

i'm having a problem getting the databases to store the characters the same way

i understand that sql server's unicode is really UCS-2 and oracle's is UTF-8

is there a collation setting I can use to get them insync, or do i have to write a program to convert it (using multibyteToWideChar) ??

thanks.