Hello,
Haven't been able to get this to work and am hoping somebody here has some advice for me.
I have a worksheet that will contain both Chinese and English characters, sometimes in the same cell, and I'm having some trouble getting it to write to my SQL table properly. I am connecting with an ADOB string using SQL Server Native Client 11, if that's relevant. In SQL, the fields I am writing to are set up as nchar(1000), and when I enter the characters directly via MSFT SQL SERVER MANAGEMENT STUDIO query, they display properly.
However, when I run them via my script, I end up with the dreaded multiple question marks in place of the characters.
In that script, each field I'm loading is stored in a variable with apostropies appened at beginning and end, which is then used in the query:
(I can't add my code -- getting blocked by the succuri firewall)
I'm hesitant to change my windows settings because I have dozens of other scripts that I run daily and am quite afraid to mess them up, unless it's something I can set via my script then reset at the end of the script.
Hopefully I've given enough info here but if I can clarify in any way, please let me know- and thank you in advance for any guidance.
Bookmarks