Convert all numbers as strings

[xdebbie]

Great issue for those participating on Hacktoberfest!

I need all data from the columns "year", "album", "artist" and "label" to be registered in the database as "string" (varchar/text) EVEN when the value is a number. E.g., right now if the year is 2020 it will register as an INT, and I need it to be a string "2020".

[dhruvdesmond]

hi,
Can you assign this to me?
I can fix this.

[xdebbie]

Sure! You would save the day if you manage it! Thanks for trying mate

[jp2373]

Is it done? Otherwise, I want to try it.

[xdebbie]

Not done yet, you can feel free to try too @jp2373 ! Thank you very much

[jp2373]

Hey @xdebbie, I tried to set up the environment just like yours but kept running in issues and couldn't do it at the end. You can assign this to someone else if you want to. After looking at your code my suggestion would be to typecast them to string as soon as you scrap them and then adding them into the database(So if the year is 2020 then str(2020) can be "2020"). I am not sure if it will work but you can try that.

[xdebbie]

Hi @jp2373 , thanks for the tip and for trying, I was trying to add str() to my variables too but didn't succeed... Do you know what errors you ran into when trying to compile the project?

[dhruvdesmond]

Hi @xdebbie . I think I found the problem. Maybe you can check this link.
https://stackoverflow.com/questions/53382202/sqlite-string-automatically-converted-to-integer-in-string-column