Results 1 to 4 of 4

Thread: unicode data

  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: unicode data

    I am getting unicode data into my database table and I am unable to see that data in my quesry analyzer. Can I convert that unicode data into varchar datatype?
    AND how can i See that unicode data.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Do you mean see that data in Query Analyzer on your lap/desktop? Then you will have to install the appropriate code pages on your local machine, then set the results pane to display in a font that understands that there are more than 250 characters. I am using "Courier New (Western)" and it seems to work out well.

  3. #3
    Join Date
    Apr 2003
    Posts
    176
    I am getting a character which looks like a square. Whats that character and how can remove that characte from my data.

    Thanks.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The easiest way to "see" a character that has no glyph (written form) in the current character set is to switch character sets until you find one that has a glyph for that character. MCrowley's suggestion of Courrier (Western) is probably a good place to start.

    Another way to skin that cat is to represent the data as varbinary and look for the hex value. This is rather painful for beginners, but it works every time for every possible character. Something similar to:
    Code:
    SELECT Db_Name(), Cast(Db_Name() AS VARBINARY(50))
    -PatP

Posting Permissions

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