Aventurine Yao

Step 1: Install QT Download and install from here:  http://qt-project.org/downloads   (Locate where the "qmake" is. For example, "/Applications/Qt5.1.1/5.1.1/clang_64/bin/qmake" when I choose to install qt at "/Applicaitons/Qt5.1.1") Step 2: Install SIP Download the package from here:  http://www.riverbankcomputing.co.uk/software/pyqt/ Unzip it and "cd" into the resulted folder. python configure.py make sudo make install (Review the output messages and locate where sip is installed. For example, "/System/Library/Frameworks/Python.framework/Versions/2.7/bin/sip".) Step 3: Install PyQT Download the package from here:   http://www.riverbankcomputing.co.uk/software/pyqt/ Unzip it and "cd" into the resulted folder. python configure.py --qmake where_qmake_is --sip where_sip_is (ex. python  configure.py  --qmake /Applications/Qt5.1.1/5.1.1/clang_64/bin/qmake --sip /System/Library/Frameworks/Python.fra...

I wanted to setup MySQL to use utf-8 on the MAMP installation on my Mac. I tried the instructions from this article: http://cameronyule.com/2008/07/configuring-mysql-to-use-utf-8/ However, I kept getting error messages that are similar to this one [ERROR] /Applications/MAMP/Library/bin/mysqld: unknown variable 'default-collation=utf8_general_ci' I did some search and realized that several variables are deprecated. Reference: http://dev.mysql.com/doc/refman/5.1/en/server-options.html Therefore, I added the following lines into /Applications/MAMP/conf/my.cnf [mysql] character-set-server=utf8 [client] character-set-server=utf8 [mysqld] character-set-server=utf8 collation-server=utf8_general_ci init-connect='SET NAMES utf8' I restarted the server and mysql run successfully with relevant variables being set correctly. In the "Variables" tab under phpMyAdmin interface (ex. http://localhost:8888/MAMP/?language=English) character set c...

SELECT * FROM table_name WHERE `column_name` LIKE '%the_string_you_are_lookging_for%'

Do you regularly code and seek information on the Internet? If so, I would like to invite you to participate in a study of programmers’ online information seeking. Pei-Yao (Perry) Hung, a graduate student from the School of Information at the University of Michigan, is conducting a study to understand how programmers with various levels of expertise seek information online regarding their programming tasks. All the details (e.g., qualifications) of the study are included here: http://bit.ly/146na6b The study will span 2 weeks and take less than 30 minutes each week for you, with the option to extend it to 4 weeks if interested. If you successfully complete the study, you will receive gift cards ($20 for a pre-study interview and the first two weeks, with an additional $20 for the optional two weeks and a follow-up interview) for your effort. Please consider participating in this study and help share this information to people who might be interested. Contact Perry through pe...