?

Log in

No account? Create an account
Observations on SQL - The Cover Story
October 2013
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
 
Thu, Jul. 6th, 2006 06:27 pm
Observations on SQL

You know, when you're trying to migrate from a US Server to a server in the Netherlands, the difference between SQL_Latin1_General_CP1_CI_AS and SQL_Latin1_General_C437_CI_AS become really, really irritating. Suddenly, in a single flash of insight, Unicode goes from an psuedoacademic Best Practice to an absolute necessity in a very nontrivial way.

Tags: , ,

1CommentReplyShare

petercooperjr
petercooperjr
Peter Cooper Jr.
Fri, Jul. 7th, 2006 02:02 am (UTC)

Yeah. Unicode is like that.

The thing is, just about everything nowadays speaks Unicode just fine. In my experience, it's just that each part of the system assumes that it has to use the legacy encoding for backwards compatibility with everything else. But if you tell each part that Unicode is okay, and to speak Unicode to the next guy in the system, and to read Unicode from the previous guy, it all just wonderfully works. (The trick is telling the parts that it's okay.)

I'm a semi-regular reader of Michael Kaplan's blog on internationalization. Despite not really dealing with it much in practice, I find the problems and solutions quite fascinating. Getting computers to work in a consistent manner when the languages of the world are so completely different at times is quite a challenge.


ReplyThread