The SQLServerCentral servers are in the UK, and installed by UK personnel at Rackspace. We recently switched servers to Rackspace, off of the old servers that were installed by Red Gate IT, but they used the US settings, to exactly match the servers that used to be in CO. Even down to the time zone, which was nice for me. Made it easy for me to work on the servers, check jobs, etc.
Over the years I’ve done less management on the servers to the point where I now do almost none. That’s fine with me, but I do occasionally need to fix something that’s broken and for which I don’t have a web interface. Like today when I was trying to merge two accounts for a user. I’m sure I’ve done this today, but I had to search for someone by email to fix things.
That’s a US keyboard above, and it’s what I use. I was born and have lived in the US for all but about 7 months of my life. I buy US equipment, and that’s what I’m used to.
Today I went to type in code like this:
WHERE EmailAddress like ‘firstname.lastname@example.org’
That’s not really the email, but instead, when I hit “Execute” and got no rows, I looked at my code and saw this:
WHERE EmailAddress like ‘sjones”mydomain.com’
Apparently the UK has a different keyboard. I was on VPN, and it’s a pain to disconnect and reconnect, and the web doesn’t work for me, so I asked my wife to Google while I tried SHIFT+1, SHIFT+3, SHIFT+4, etc.
Eventually it occurred to me to try SHIFT+double quotes and that worked. However when I googled UK keyboard, I found this as the top result:
That one shows the @ symbol in the upper left. This is actually the layout that my server has.
Working with international equipment or users always brings its own challenges. I follow the Sorting It All Out blog by Michael Kaplan, and I’m amazed by all the differences he finds with different languages. That guy writes more than me, and it’s the best resource if you are worried about how different languages might affect your application. Or you’re just interested in the world languages.
Lesson learned, albeit annoyingly. At least now I know how to type with a UK keyboard.
Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest