+ Reply to Thread
Results 1 to 1 of 1

Blend of Asian and Latin characters from Sheet to SQL Table

  1. #1
    Registered User
    Join Date
    06-08-2017
    Location
    NJ, USA
    MS-Off Ver
    2016
    Posts
    13

    Blend of Asian and Latin characters from Sheet to SQL Table

    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.
    Last edited by jp_romano; 01-25-2019 at 12:30 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Find replace to fix mixed Greek and Latin characters
    By greek in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2014, 07:45 AM
  2. [SOLVED] Determine latin characters in cells
    By akotronis in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 04-17-2013, 01:50 PM
  3. Import data containing foreign, non-latin, language characters using VBA
    By drieger22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2012, 05:30 PM
  4. Diplaying Asian Characters in List View
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2010, 12:07 PM
  5. Problems viewing "Asian Characters" in ListView
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2010, 02:18 PM
  6. How to insert Asian characters into a cell?
    By Andrew in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2005, 06:36 AM
  7. Replies: 0
    Last Post: 01-28-2005, 09:43 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1