 |
Личные заметки на Zaharov.info / Естествознание / Squirrel SQL Client: How to save file in UNICODE / UTF-8 |
| Автор | Сообщение |
|
dimedrol
Администратор |
# Дата: 6 Июл 2011 11:08 - Поправил: dimedrol
Ответить 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&char acterEncoding=UTF8 This gives us ability to insert and select correctly utf-8 data (I tried to use driver properties for this - no luck) 2) 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! |