Will you never put your files on the net? If so, what will you expect to find at the remote server? Your character set? 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
