> Will you never put your files on the net? If so, what will > you expect to > find at the remote server? Your character set?
I am building an application for my company's intranet. I control the server completely. I want to fix the problem, not work around it. Besides, if this character map is as broken as I think it is then it is a bug in MySQL and should be fixed for everyone, not just me. Regards, Philip > IMO forget character mapping and use BINARY option at fields creation, > usally the contains will be upercase or lowercase, not both. The only > exeption I can think is to index - or search- a text file. > > Makis > > > > -----Original Message----- > > From: Philip Semanchuk [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, April 02, 2002 7:21 PM > > To: [EMAIL PROTECTED] > > Cc: 'Ken Menzel'; savaidis > > Subject: swe7 character set - strange mappings? > > > > > > Hi everyone, > > I am trying to understand what's going on here and I hope > you can help me. > > The swe7 characters set in swe7.conf has some really strange > > mappings in it. > > For instance, the to_upper array maps ASCII 0x7E (a tilde) to > > 0x5E (a "hat" > > aka Ctrl character). Why doesn't a tilde remain a tilde? > > > > Stranger still is the entry in the sort_order array that > maps tilde (0x7E) > > to Y (0x59). And worst of all, the last letters in the Swedish > > alphabet (ä, > > å and ö == 0xE4, 0xE5 and 0xF6) map to themselves which > means that MySQL > > sorts them case sensitively while the rest of the alphabet is sorted > > case-INsensitively. Similar problems are present in the to_upper and > > to_lower arrays so that lower('Ö') (e.g.) returns a capital letter. > > > > I realize that I can make my own character set and I will do so > > in order to > > fix the problems I am seeing. But first I want to make sure that the > > problems I describe above are indeed problems due to a > buggy character set > > and not user error on my part. > > > > There's a good reference to the ISO-8859 character set that > Swedish uses > > here: > > http://czyborra.com/charsets/iso8859.html#ISO-8859-1 > > > > I am using version 3.23.41. > > > > Thanks in advance > > Philip > > > > filter fodder: sql query > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php