Post reply

alfa symbol

  • March 15, 2011 at 5:26 am

    #389050

    Hi all,

    Using a table with a field=char(90) database collation=Latin1_General_Cl_AS , is there a way that we can insert an alfa symbol = 97 (decimal)?

    Doing copy paste from Word it turns to -> 

    Thanks.

    http://www.arcns.no.sapo.pt

  • March 15, 2011 at 5:32 am

    #1298762

    i believe the alpha symbol would require an NCHAR column, and nnot a char; the alpha is in the extended ascii character set.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 15, 2011 at 6:44 am

    #1298802

    example:

    /*

    (No column name)(No column name)(No column name)(No column name)

    a97aa

    */

    DECLARE @nc NCHAR(1)

    SET @nc = N'a'

    select

    N'a',

    ASCII('a'),

    CONVERT(CHAR(1),(@nc)),

    CONVERT(NCHAR(1),(@nc))

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 15, 2011 at 8:20 am

    #1298869

    Lowell,

    Thank you for your answer. It help a lot, to solve my question.

    http://www.arcns.no.sapo.pt

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

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