Quite A Nice RFC

published at 19 Oct, 2008 by Szymon Lipiński tags: rfc
                        ARPAWOCKY

               Twas brillig, and the Protocols
                    Did USER-SERVER in the wabe.
               All mimsey was the FTP,
                    And the RJE outgrabe,

               Beware the ARPANET, my son;
                    The bits that byte, the heads that scratch;
               Beware the NCP, and shun
                    the frumious system patch,

               He took his coding pad in hand;
                    Long time the Echo-plex he sought.
               When his HOST-to-IMP began to limp
                    he stood a while in thought,

               And while he stood, in uffish thought,
                    The ARPANET, with IMPish bent,
               Sent packets through conditioned lines,
                    And checked them as they went,

               One-two, one-two, and through and through
                    The IMP-to-IMP went ACK and NACK,
               When the RFNM came, he said "I'm game",
                    And sent the answer back,

               Then hast thou joined the ARPANET?
                    Oh come to me, my bankrupt boy!
               Quick, call the NIC! Send RFCs!
                    He chortled in his joy.

               Twas brillig, and the Protocols
                    Did USER-SERVER in the wabe.
               All mimsey was the FTP,
                    And the RJE outgrabe.
                                                       D.L. COVILL
                                                          May 1973

rfc527

 

PostgreSQL Collation - part 2

published at 11 Oct, 2008 by Szymon Lipiński tags: collation postgresql

Due to many questions about the PostgreSQL collation that were asked after my last short article about that, I decided to write some more about the current collation situation in PostgreSQL.

What The Collation Is

The collation setting is responsible for correct working functions such as

 

PostgreSQL Collation - part 1

published at 02 Oct, 2008 by Szymon Lipiński tags: database mysql postgresql

PostgreSQL is (IMHO) much better than MySQL but unfortunately it still lacks one of the greatest MySQL features: encoding.

MySQL Collation

Locale settings in MySQL are great. You can have different collation set for each database, table and even column (the same as it is in Interbase/Firebird). This gives the opportunity to simplify the database structure.

For example (I know, a very simplified example) when you have even a simple blog database and want to create a multilingual blog. Then it is enough to create one table for posts with two columns for body, each with different collation.