Something that I’ve been interested in for a while now is the semantic web. I don’t claim to be any kind of expert on it and have barely scratched the surface.
After finding about the Open Calais service from Thompson Reuters I was pretty excited. I’ve created a custom tag that sends data to the service [...]
Entries Tagged as 'Code'
cfCalais – A Coldfusion tag to easily create semantic data
February 16th, 2010 · 6 Comments · Code, coldfusion
Finding international characters with MySQL
August 19th, 2009 · Comments Off · MySQL
I recently had to find the rows in a database that contained any multibyte characters. My first thought was to leverage the difference between length() and char_length(). The query would be similiar to this:
Select pKey, dataCol
From myTable
Where length(dataCol) != char_length(dataCol)
To my surprise this query didn’t work. After mulling it over in my mind, I tried [...]