Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. how to insert mathematical symbols in database

how to insert mathematical symbols in database

Scheduled Pinned Locked Moved Database
csharpdatabasetutorial
8 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • P Offline
    P Offline
    pankaj3086
    wrote on last edited by
    #1

    how to insert mathematical symbols like integration diffrenciaton symbols in database.so that it can be redable in .netframework when it is retrived from databse

    L P 3 Replies Last reply
    0
    • P pankaj3086

      how to insert mathematical symbols like integration diffrenciaton symbols in database.so that it can be redable in .netframework when it is retrived from databse

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #2

      You have not indicated what database and version you use. In simple terms, you've to use a collation that supports unicode characters. For SQL Server, this[^] will be a starting point.

      P 1 Reply Last reply
      0
      • L Lost User

        You have not indicated what database and version you use. In simple terms, you've to use a collation that supports unicode characters. For SQL Server, this[^] will be a starting point.

        P Offline
        P Offline
        pankaj3086
        wrote on last edited by
        #3

        shameel thanks for replying actually iam using sql server 2005 and sql database and i want to know how to insert signs of inegration, diffrenciation and limits in database....

        J 1 Reply Last reply
        0
        • P pankaj3086

          shameel thanks for replying actually iam using sql server 2005 and sql database and i want to know how to insert signs of inegration, diffrenciation and limits in database....

          J Offline
          J Offline
          jschell
          wrote on last edited by
          #4

          Same answer still applies. 1. It depends on what you 'mean' by "symbol" 2. If and only if the answer to 1 means that unicode is suitable then you have the following choices a. Set up the database to accept unicode. b. Encode the data into the character set that the database does support (probably to base64) and live with the fact that you won't see the characters in the database itself - you will need to use your application.

          P 1 Reply Last reply
          0
          • J jschell

            Same answer still applies. 1. It depends on what you 'mean' by "symbol" 2. If and only if the answer to 1 means that unicode is suitable then you have the following choices a. Set up the database to accept unicode. b. Encode the data into the character set that the database does support (probably to base64) and live with the fact that you won't see the characters in the database itself - you will need to use your application.

            P Offline
            P Offline
            pankaj3086
            wrote on last edited by
            #5

            @jschell by symbol i excatly means what we use in maths i mean symbol to represent inegration and diffrenciation i hope u can understand what i mean to say..

            J 1 Reply Last reply
            0
            • P pankaj3086

              how to insert mathematical symbols like integration diffrenciaton symbols in database.so that it can be redable in .netframework when it is retrived from databse

              L Offline
              L Offline
              Lost User
              wrote on last edited by
              #6

              pankaj3086 wrote:

              how to insert mathematical symbols like integration diffrenciaton symbols in database.so that it can be redable in .netframework when it is retrived from databse

              Can you post an example? Show us what it is that you want to store, 'cause as it is, you won't get much valuable answers. All text-encodings are supported. No, text does not support all math. So, how are your users going to represent their content? MathML[^] would be a good choice, and you can store it in a VARCHAR column.

              Bastard Programmer from Hell :suss:

              1 Reply Last reply
              0
              • P pankaj3086

                how to insert mathematical symbols like integration diffrenciaton symbols in database.so that it can be redable in .netframework when it is retrived from databse

                P Offline
                P Offline
                PIEBALDconsult
                wrote on last edited by
                #7

                I agree with Eddy. You don't need to store the actual symbols in the database (although you can if it makes sense). The symbols are more a matter of UI. I second using XML or similar to persist the concept of the expression.

                1 Reply Last reply
                0
                • P pankaj3086

                  @jschell by symbol i excatly means what we use in maths i mean symbol to represent inegration and diffrenciation i hope u can understand what i mean to say..

                  J Offline
                  J Offline
                  jschell
                  wrote on last edited by
                  #8

                  I understand what a mathematical symbol in mathematics means. However that has nothing to do with how you represent the idea on a computer. For example I could use a paint program to create a formula and then store it in a database. Or, as I suggested, unicode has mathematical representations. There are other possibilities. It is up to you, based on your business needs, to first determine the form (the data on the computer) that your representation will take.

                  1 Reply Last reply
                  0
                  Reply
                  • Reply as topic
                  Log in to reply
                  • Oldest to Newest
                  • Newest to Oldest
                  • Most Votes


                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • World
                  • Users
                  • Groups