I'm having a bit of a strange issue with Japanese characters.
1) They're in the Excel file I'm importing.
2) They show up in the raw table I first load the file to, when I select results to text or file, but not to grid. In grid they show up as black rectangles that are hollow in the center.
3) They don't show up at all in the secondary staging table, only question marks.
I will post anything I can to help, but I'm not sure how to generate dummy data. I can't post what I have, because it's from a client file.
I can post my table creation code, but they're kind of ridiculous stored procedures full of cursors (which will probably give some of you a twitch) that have been in place since before I ever had an inkling I'd be touching SQL at work, and a year and a half into my SQL life I have no idea how to improve upon.
What I'm really looking for are some things to check on to see why this might be happening. Maybe a setting somewhere, but I'm not counting on being that lucky.
I've tried various collate selects, but they don't change how the data displays in either table. I've put in a request for the MS OLEDB driver to be updated (it's currently 4.0), but I'm really not even sure if that could be an issue. Windows *seems* to have the language packs I would need, since I can see the characters in some places.
Anyway, I'd appreciate any suggestions.