Hi all,
I need some input from folks who are a bit more knowledgeable on Internationalization than I am.
I'm working on an application that requires multiple Asian and Eastern European languages to be displayed in a single (Web app) with data coming from SQL Server. I need to be able to both read and write data.
I can actually get all of what I need to work for a single language - the language that I have configured for Unicode->Ansi conversion on the system in the Regional Settings. But all others don't work unless I switch to that particular language.
I've written up were I am at with this in my WebLog (and if you're doing this sort of thing there are a few interesting side notes with this BTW even if it doesn't have the solution to the problem <g>).
http://west-wind.com/weblog/posts/1156.aspxTHe questions are basically this:
1 How do I get the data back from SQL Server consistently to support multiple languages?
2 How do I get the data capture from the Web Page (UTF-8 formatted and that's workign fine) into something that I can put back into SQL Server.
#2 I can sort of hack by working witht he original UTF-8 and converting it to binary data then forcing that into SQL Server using NCHAR() for any extended characters. Messy as all hell.
If anybody has any ideas I'd very much appreciate some feedback! Code and basic background is all in the WebLog entry...