Squirrel SQL Client: How to save file in UNCODE / UTF-8

by Dmitrijs Zaharovs tools

So, Squirrel SQL is one of my favorives freeware sql client,
but there are some tricks, working with UTF-8 encoded data:

  1. First of all, for example, working with MySQL don't forget to adjust your connection string for unicode:

URL line of your connection setting should look like this:

jdbc:mysql://localhost:3306/mydatabase?useUnicode=true&characterSetResults=UTF-8&characterEncoding=UTF8

This gives us ability to insert and select correctly utf-8 data
(I tried to use driver properties for this - no luck)

  1. And if you're saving your sql script file, containing UTF-8 symbols,
    adjust startup file - "squirrel-sql.bat"

at the bottom of file (bold selected):

start "SQuirreL SQL Client" /B "%LOCAL_JAVA%" -Xmx256m -Dsun.java2d.noddraw=true -Dfile.encoding=UTF-8 -cp %SQUIRREL_CP% -splash:"%SQUIRREL_SQL_HOME%/icons/splash.jpg" net.sourceforge.squirrel_sql.client.Main %TMP_PARMS%

That's it!