Category: Databases issues and tips

Change varchar character set to UTF8 in Firebird database

Bellow is a firebird SQL script that will help you easily to change the character set of all varchar fields of a database.

 

Last modified.: 07/04/2019 Databases issues and tips

Import an SQL file using the command line in MySQL – Centos linux

Use the following:

If your database has errors and you want to import it anyway, use the –force (-f) flag. Rather than stopping on the offending statement, MySQL will continue and just log the errors to the console:

   

Fix corrupted database – Firebird

Fix corrupted database

 

Last modified.: 14/04/2017 Databases issues and tips

Problem with simultaneous use of another version firebird

In some cases, the firebird database may be blocked and not opened simultaneously with another firebird version. In order to solve the problem,at the folder:

Execute the commands:

Add auto modified timestamp field to a table (MySQL)

First, create the field for the timestamp in the table you want.

Then, create the trigger. Just replace the word “table” with your table name.

 

Last modified.: 23/07/2015 Databases issues and tips, Support | Downloads

ORA-01045:user name lacks CREATE SESSION privilege; logon denied (Oracle)

If you get this message/error in Oracle: ORA-01045:user name lacks CREATE SESSION privilege; logon denied   The Solution is simple. Just open command prompt and type the following:

Replace “USER-NAME” with the message’s user name.   source:http://osamamustafa.blogspot.gr/2012/05/ora-01045user-name-lacks-create-session.html

Last modified.: 23/07/2015 Databases issues and tips