Post reply

MultiLanguage Support for Numerals

  • July 10, 2012 at 10:54 pm

    #260919

    Hi All,

    I have a requirement that I have a table in which we want to add a column for Price which will save the price of a commodity but this would be in different language numeral i.e. in Chinese Numerals.

    This I have achieved with the help of UTF8String UDT ( http://msdn.microsoft.com/en-us/library/ff877964 ) but this will save as characters not the numerals. Now our concern is that we want do the mathematical manipulations on that particular field like Addition, Multiplication, Division, Substraction, etc.

    My Table looks like:

    Thanks in Advance!!

    Sumit Rastogi:cool:

  • July 10, 2012 at 11:18 pm

    #1511326

    Thanks

  • July 11, 2012 at 7:00 am

    #1511505

    Sumit,

    Please script out your table as a DDL (CREATE TABLE) statement and give us sample data in the form of an INSERT script so we can help you out.

    I assume your question is "How do I make it numerals?", yes?

    My question is (not being able to see whatever image you inserted into your post), why does a numeric column need multilingual support? Surely you can put whatever multilingual signs are required into a separate column.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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