Webdesign Archives -

Converting MySQL from latin1 to utf8

10/05/2016 0

Edit /etc/mysql /my.cnf Under [client] add

default-character-set = utf8

1	default-character-set = utf8

Under [mysqld] add

collation_server = utf8_general_ci
character-set-server = utf8

1 2	collation_server = utf8_general_ci character-set-server = utf8

Dump you database to a file

 mysqldump -u USERNAME -pDB_PASSWORD --opt --skip-set-charset --default-character-set=latin1
           --skip-extended-insert DATABASENAME --tables TABLENAME >
           DUMP_FILE_TABLE.sql

1

2

3

mysqldump -u USERNAME -pDB_PASSWORD --opt --skip-set-charset --default-character-set=latin1

--skip-extended-insert DATABASENAME --tables TABLENAME >

DUMP_FILE_TABLE.sql

Then edit your dump file and change every CHARSET=latin1 Read More

Flash rounded corners

11/04/2011 0

Did you ever try to make rounded corners in Adobe Flash? Did they ever look like a truck hit them? If they do, you probobly Read More

w3schools & HTML5

28/03/2011 0

I’ve been following the development of HTML5, even though it’s been a while since I really checked it out for myself. Today I was thinking Read More

WordPress php sql running twice

12/01/2011 4

I was making this small feature in php where I want a script to collect links. What I want to do is have a text Read More

Gallery of diversity

08/01/2011 0

Just testing the NextGEN Gallery plugin for WordPress [nggallery id=4] Pictures are taken using an iPhone4 with Instagram