Japanese Characters?

  • I'm having trouble inserting japenese characters into a SQL db.  We have tried the Language packs, and installing the SP3a for SQL. We still can’t get the Japanese to work.

    I also tried using the N character in the INSERT statement as I've read and nothing seems to work, they continue to show up as question marks.

    Is there anything else I need to install to handle japanese unicode characters.

    Brian

     

  • This any help?

    http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarsqlsg/html/msdn_interntl.asp

     

    --------------------
    Colt 45 - the original point and click interface

  • I had a practical some times back when I use insert command for datatime field. I got this problem when I am doing this korean charactors.

    When this data time was ignaored  it worked. I didn't get a any workarround for this




    My Blog: http://dineshasanka.spaces.live.com/

  • Hi Brian (are you the real famous SQL Brian Moran?).

    First thing to check - Is the database column nchar or nvharchar. Then how are you trying to do the insert and then how are you looking at the data - Query Analyzer?

    Thanks,

    Adam

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply