SQL Server 2005 text fields multi-language.

Posted on 2007-10-12
Last Modified: 2013-11-26
I have data that is being input to a SQL Server2005 table in different languages.

Everything works...Japanese, Italian, Spanish...blah, blah...blah...

But the russian keeps going in with ????? in places.  Is there a patch I need?
Question by:lrbrister
    1 Comment
    LVL 27

    Accepted Solution

    What is the collation for the database, server, column?

    SELECT CONVERT (varchar, SERVERPROPERTY('collation'))
    SELECT * from ::fn_helpcollations()

    SELECT CONVERT (varchar, DATABASEPROPERTYEX('database_name','collation'))

    sp_help table_name

    Are you saying that the same column in a table can accept multiple languages? Are there more than one column? Are they in the same table?

    You mention Japanese - is it using the Kanji alphabet?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    In my previous article ( we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now