October 9, 2019 at 1:15 am
How can I put the result of HTML into a DB table?
I extracted the info using LMXL, Python.
Thanks
October 9, 2019 at 7:25 am
I guess HTML can be stored with VARCHAR(MAX) or XML Data Types. If this is what you wanted?
October 16, 2019 at 2:49 pm
Are you asking the best way to store the data?
The HTML character set was extended to ISO 10646, which is similar to Unicode. I would recommend using nvarchar (MAX) or a lower string size. You could also use the XML datatype if you are extracting the html elements and storing them in an XML format in your python code.
For actually connecting to your SQL Database, I would recommend using the pyodbc driver. More information can be found at the link below:
https://docs.microsoft.com/en-us/sql/connect/python/python-driver-for-sql-server
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply