I am following instructions online to create a database in pgAdmin4. I have successfully imported a csv file and created a table. However, I cannot select anything from the table. My code is: SELECT * FROM transfers; Error message is: ‘utf-8’ codec can’t decode byte 0xc3 in position 0: unexp…
Tag: encoding
How to store number in shortest possible size?
I will be adding comments into my website and I want to have a tree structure so each comment can have a parent. This creates a problem when retrieving comments because each comment would have to be traversed for children and this is unacceptable when it comes to database storage. There are various solutions …
How to reproduce the behavior of SQL NVARCHAR in Python when generating a SHA-512 hash?
I have the following SQL query SELECT CONVERT(VARCHAR(254), HASHBYTES(‘SHA2_512’, CONVERT(NVARCHAR(24), ‘2020-05-27 00:00:00.000’, 127)), 2) that generates the hash value …
Encoding special characters SQL to R and back
I have a problem passing data from R to SQL and then reading it back The original data is from some excel files and have the following word: Průmyslový Using latin1 for encoding depreciates the u within the word Prumyslový Using latin2 for encoding changes the accent of the u Prùmyslový Which encoding could i…
How to handle umlaute like Ä Ö Ü in Coldfusion SQL query to insert into database?
I want to insert a string into my database with Coldfusion. However it contains umlauts like Ä, Ö and Ü (German). The umlauts are displayed different than they should in the database. For example I …
How to SQL join tables, selecting the largest value in Access-VBA Function?
I currently have the following Access VBA function, which operates as explained in a previous question (very useful for understanding this question): However, instead of Field3 containing either yes or no, in my data it can contain one of several values. For simplicity, let’s say that these values can b…