Search This Blog

Wednesday, April 20, 2016

hindi characters going as question mark while using java and mysql

change the database string to
url=jdbc:mysql://localhost:3306/PT?useUnicode=true&characterEncoding=UTF-8
to enable unicode character support.

change table character set also
image

Tuesday, April 19, 2016

set m2_repo as maven variable in eclipse

To set m2_repo, go to your users folder and search .m2/repository and set this path in eclipse – window-preferences-buildpath-classpathvariable
set M2_REPO –> .m2/repository

rebuild

Thursday, April 7, 2016

mysql login via command line

go to mysql/bin

mysql.exe -u root -proot dbname -h localhost

taking dump

mysqldump.exe -uroot -proot dbname >dbname.sql