Friday, 19 May 2006

Thursday, 18 May 2006

There's always an excuse...

I can always find an excuse for not running, biking, going for a walk, ... just about anything. My excuse this week? I don't want to bike in thunder showers. And every day this week they have said that it will!! Grrr.... arrggg... I should just suck it up. *sigh*

Tuesday, 16 May 2006

Nice

I gotta get me one of these... it's more than meets the eye. ;-)

Monday, 15 May 2006

Sorting it all out

One of the things that I learned in the last month or so is that sorting in different languages, with accented characters, isn't the same. :-( I'm going to outline a case-insensitive example in Java and Oracle and my experience with that.

With Oracle as a back-end, if I wanted to order by a String column I would call the upper (or lower) method on the field to return a sorted list. I knew that this was a bit of a hack because some (European?) languages have strange conversions from upper to lower case. I remember reading that's why they made XML case sensitive...

So, with the work that I was doing I run some sql (or hql) with something like "... order by (UPPER(col_name))" and in my test suite I would check that it was sorting correctly by using a case insensitive comparator. Now, to find out that it will not work you just have to read the documentation. But course I never thought that it applied to what I was doing.

Here's an example: if you have the names "BÈretta" and "Butler", the default in Java and using upper in the db are both to return "BÈretta" after "Butler". Not correct in a French locale.

To sort it correctly in Oracle, you should do something like:
"order by nlssort(col_name, 'NLS_SORT = FRENCH')"

To sort it correctly in Java, you would have to use a collator like the RuleBasedCollator. Example:
Collator collator = Collator.getInstance(Locale.CANADA_FRENCH);
// make the ordering case-insensitive
collator.setStrength(Collator.SECONDARY);

The Collator is actually very interesting because you can put different emphasis on different parts of the sorter. Really kind of cool.

Friday, 12 May 2006

Security over Freedom

Pretty much this whole /. thread is a good read, with the following being the best part:

"The masses almost always value security over freedom until they have so little of either a revolution is born."

WotD: wonks

New word for me: wonks. It's not what I thought it would be...