Re: Re: MySQL bug? - problems with character-set
Andis, Friday, August 02, 2002, 9:07:54 AM, you wrote: A It's just a simple example, because I don't want send latvian-specific A symbols. This problem occurs with latvian-specific symbols only. A Configuration file I cheked some 4-5 times. I'm confused now. To convert correctly from upper case to lower case and vice versa you should specify proper character set. If you look into *.conf files in the charsets dir you can see 4 arrays there. Two of them, to_lower[] and to_upper[], contain the lowercase and uppercase characters corresponding to each member of the character set. What character set do you use in MySQL? And what character set is used for Latvian language? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Re: Re: MySQL bug? - problems with character-set
I created character-set myself. Here, in Latvia, we use windows-1257. Problem is, when I use MySQL under Linux, conversation occurs better. Under windows98 I have problems as I wrote before. Cheracter-set I created myself, because included isn't correct. Andis - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 02, 2002 1:05 PM Subject: Re: Re: MySQL bug? - problems with character-set Andis, Friday, August 02, 2002, 9:07:54 AM, you wrote: A It's just a simple example, because I don't want send latvian-specific A symbols. This problem occurs with latvian-specific symbols only. A Configuration file I cheked some 4-5 times. I'm confused now. To convert correctly from upper case to lower case and vice versa you should specify proper character set. If you look into *.conf files in the charsets dir you can see 4 arrays there. Two of them, to_lower[] and to_upper[], contain the lowercase and uppercase characters corresponding to each member of the character set. What character set do you use in MySQL? And what character set is used for Latvian language? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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 - 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
Re: Re: Re: MySQL bug? - problems with character-set
Andis, Friday, August 02, 2002, 1:57:12 PM, you wrote: A I created character-set myself. Here, in Latvia, we use windows-1257. A Problem is, when I use MySQL under Linux, conversation occurs better. Under A windows98 I have problems as I wrote before. Cheracter-set I created myself, A because included isn't correct. Seems, your to_lower[] array is not correct. Unfortunately, I don't know Latvian language and can't tell you what is wrong :( You say that included character set is not correct. Do you mean cp1257 ? If so, can you explain what is wrong with character set? Can you provide your own character set with explanation of changes that you did? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Re: Re: Re: MySQL bug? - problems with character-set latvian.conf [1/3]
From: Andis [EMAIL PROTECTED] To: [EMAIL PROTECTED], Victoria Reznichenko [EMAIL PROTECTED] References: 001d01c2394e$85803740$[EMAIL PROTECTED] [EMAIL PROTECTED] 003601c239ea$f0f7d720$[EMAIL PROTECTED] [EMAIL PROTECTED] 001001c23a13$5ba93280$[EMAIL PROTECTED] Victoria Reznichenko [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Re: Re: Re: MySQL bug? - problems with character-set Date: Fri, 2 Aug 2002 17:57:53 +0300 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary==_NextPart_000_002C_01C23A4E.20042D80 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600. X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600. This is a multi-part message in MIME format. --=_NextPart_000_002C_01C23A4E.20042D80 Content-Type: text/plain; charset=iso-8859-4 Content-Transfer-Encoding: 7bit Here is my conf file. Also I send my Excel file, where with yellow is marked symbols which is used in Latvian language. Of course, also we use such symbols as W, X, Y etc. This means, for right sorting all symbols with ascii code from 32 to 255 better is include in character-set definition. I hope, that you'll see xls file as I see :)). Andis - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 02, 2002 3:41 PM Subject: Re: Re: Re: MySQL bug? - problems with character-set Andis, Friday, August 02, 2002, 1:57:12 PM, you wrote: A I created character-set myself. Here, in Latvia, we use windows-1257. A Problem is, when I use MySQL under Linux, conversation occurs better. Under A windows98 I have problems as I wrote before. Cheracter-set I created myself, A because included isn't correct. Seems, your to_lower[] array is not correct. Unfortunately, I don't know Latvian language and can't tell you what is wrong :( You say that included character set is not correct. Do you mean cp1257 ? If so, can you explain what is wrong with character set? Can you provide your own character set with explanation of changes that you did? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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 --=_NextPart_000_002C_01C23A4E.20042D80 Content-Type: application/octet-stream; name=latvian.conf Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename=latvian.conf # Configuration file for the latvian character set. # Created for case-sensitive record search=0A= # Created accord with windows-1257 (iso-8859-4) codepage=0A= # Created by Andis Grasis Rihards Grasis=0D e-mail:[EMAIL PROTECTED]=0A= # The ctype array must have 257 elements. 00 20 20 20 20 20 20 20 20 20 28 28 28 28 28 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 48 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 84 84 84 84 84 84 84 84 84 84 10 10 10 10 10 10 10 81 81 81 81 81 81 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 10 10 10 10 10 10 82 82 82 82 82 82 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 10 10 10 10 20 01 20 10 20 10 10 00 00 20 10 20 10 20 10 10 10 20 10 10 10 10 10 10 10 20 00 20 10 20 10 10 20 48 20 10 10 10 20 10 10 10 10 01 10 10 10 10 01 10 10 10 10 10 10 10 10 10 10 02 10 10 10 10 02 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 10 01 01 01 01 01 01 01 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 10 02 02 02 02 02 02 02 10 # The to_lower array must have 256 elements. 00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F 10 11 12 13 14 15 16 17 18 19 1A 1B 1C 1D 1E 1F 20 21 22 23 24 25 26 27 28 29 2A 2B 2C 2D 2E 2F 30 31 32 33 34 35 36 37 38 39 3A 3B 3C 3D 3E 3F 40 61 62 63 64 65 66 67 68 69 6A 6B 6C 6D 6E 6F 70 71 72 73 74 75 76 77 78 79 7A 5B 5C 5D 5E 5F 60 61 62 63 64 65 66 67 68 69 6A 6B 6C 6D 6E 6F 70 71 72 73 74 75 76 77 78 79 7A 7B 7C 7D 7E 7F 80 81 82 83 84 85 86 87 88 89 8A 8B 8C 8D 8E 8F 90 91 92 93 94 95 96 97 98 99 9A