# Change MySQL server encode
# By calling the following SQL you can see the current encoding.
# show create table xxx;
# show variables like 'char%';
mysql$ alter table xxx character set utf8;
mysql$ alter table xxx change sub1 sub1 varchar(256) character set utf8;
mysql$ set names utf8;
mysql$ set character_set_database=utf8
mysql$ set character_set_server=utf8
#On the client to connet to DB set the following param in URL
jdbc:mysql://localhost/blojsom?autoReconnect=true&useUnicode=true&characterEncoding=utf-8
The Answer to Life, the Universe, and Everything
Showing posts with label encoding. Show all posts
Showing posts with label encoding. Show all posts
Thursday, November 29, 2007
MySQL Encoding
You need to change params for the server and the client.
Sunday, May 13, 2007
Encoding to 3gp file for mobile phones
If h/s support AAC.
If not
For video editing on Linux, LiVES would be very nice.
#ffmpeg -i infile.mpeg -vcodec mpeg4 -r 15 -b 128k -s qcif -acodec aac -ar 8000
-ac 1 -ab 13 -f 3gp -y output.3gp
If not
ffmpeg -i infile.mpeg -vcodec mpeg4 -r 15 -b 128k -s qcif -acodec amr_nb -ar 8000
-ac 1 -ab 13 -f 3gp -y output.3gp
For video editing on Linux, LiVES would be very nice.
Subscribe to:
Posts (Atom)