EmergencyEMERGENCY? Get 24/7 Help Now!

Large result sets vs. compression protocol

 | December 20, 2007 |  Posted In: Insight for Developers

mysql_connect() function in PHP’s MySQL interface (which for reference maps to mysql_real_connect() function in MySQL C API) has a $client_flags parameter since PHP 4.3.0. This parameter is barely known and almost always overlooked but in some cases it could provide a nice boost to your application. There’s a number of different flags that can be […]

Read More

Fixing column encoding mess in MySQL

 | December 18, 2007 |  Posted In: Insight for Developers

Just had an interesting issue with an encoding mess on a column containing non-ASCII (Russian) text. The solution was not immediately obvious so I decided it’s worth sharing. The column (actually the whole table) was created with DEFAULT CHARSET cp1251. Most of the data was in proper cp1251 national encoding indeed. However, because of web […]

Read More