I recently wrote a python script to extract some data from a JSON file and use it to generate some SQL Insert values for the following statement: The names of some of the attributes are different in my SQL table but the same values are used (example cardClass in the JSON file/Python script is referred to as c…
Tag: utf-8
H2 org.h2.jdbc.JdbcSQLSyntaxErrorException occurs when executing a script file in a h2 database
I have used java -cp h2-1.4.199.jar org.h2.tools.RunScript -url jdbc:h2:mem:db1 -script infra_params.sql command to execute below sql script in a H2 database. infra_params.sql file:- DROP TABLE IF …
How to create a database with UTF-8 collation in PostgreSQL on Windows?
I’m configuring PostgreSQL db for the Bitbucket Server on Windows. In the official guide it says that: The database must be configured to use the UTF-8 character set. It doesn’t strictly say that you have to set collation to UTF-8, but for other atlassian procucts it’s recommended so I assum…
A script to change all tables and fields to the utf-8-bin collation in MYSQL
Is there a SQL or PHP script that I can run that will change the default collation in all tables and fields in a database? I can write one myself, but I think that this should be something that readily available at a site like this. If I can come up with one myself before somebody posts one, I will