Post reply

adding the 'ohm' character in a sql database

  • July 21, 2011 at 4:02 am

    #244689

    is it possible to add the ohm ( Ω

    )character to a cell in a sql database?

    i'm looking to store it and then output it to a website form.

  • July 21, 2011 at 4:11 am

    #1356240

    If you mean this

    SELECT NCHAR(8486)

    you'll need to use an NVARCHAR or NCHAR column

    ____________________________________________________

    Deja View - The strange feeling that somewhere, sometime you've optimised this query before

    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

  • July 21, 2011 at 4:30 am

    #1356247

    that is the character i'm looking for. how would i store it as that character within the database though? I changed my database column to an nvarchar column and added adding 'NCHAR(8486)' into the cell but it just shows it as that, rather than converting it to the ohm character.

  • July 21, 2011 at 5:10 am

    #1356259

    create table Test1 (Text nvarchar(max))

    Go

    insert into Test1 SELECT NCHAR(8486)

    Go

    select * from Test1

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • July 21, 2011 at 6:06 am

    #1356277

    i see where i was going wrong.

    i was right clicking the table name in the Object Explorer and selecting Edit Top 200 Rows and then typing in NCHAR(8486) into the cell.

    when i run an update statement

    update table1

    set row1 = '0.35' + NCHAR(8486)

    where id = 1

    it works.

    thanks

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

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