I have an installshield installation that connects to a SQL Server instance and inserts words from different languages.
After the import runs When I query the data from the database characters from languages with different alphabets are showing up as jumbled text. An example of this would be Russian.
It turns into Ð¡Ñ‚Ð°Ñ‚ÑƒÑ instead of the correct Russian characters.
How can I fix Installshield so that it inserts the text correctly?
Solution: from Panagiotis Kanavos
I forgot to add the N before the strings.
EG N'[Russian text]’
Advertisement
Answer
From the characters (regular pairs,same first character), it looks like UTF16 text was stored as single-byte text in the database. Did you forget to add the N prefix in front of any Unicode literals perhaps?