estonia charset and upper/lower case (fwd)

Hello!

When I run mysql with default-charset = estonia, it makes difference
between upper and lower case. With latin1 charset no such distinction are
made. I think this is a bug. Could someone help me out?

--
Lauri Anton
( anton@EENet.ee )
( +3727302126 )


How-To-Repeat:

----- charset:estonia -----
Server version: 3.23.49
Client characterset: latin1
Server characterset: estonia


mysql> select * from a;
+----+------+
| id | str |
+----+------+
| 1 | AAA |
| 2 | Aaa |
| 3 | aaa |
+----+------+
3 rows in set (0.00 sec)

mysql> select * from a where str like 'AAA';
+----+------+
| id | str |
+----+------+
| 1 | AAA |
+----+------+
1 row in set (0.00 sec)


----- charset:latin1 ------
Server version: 3.23.49
Client characterset: latin1
Server characterset: latin1

mysql> select * from a;
+----+------+
| id | str |
+----+------+
| 1 | AAA |
| 2 | Aaa |
| 3 | aaa |
+----+------+
3 rows in set (0.00 sec)

mysql> select * from a where str like 'AAA';
+----+------+
| id | str |
+----+------+
| 1 | AAA |
| 2 | Aaa |
| 3 | aaa |
+----+------+
3 rows in set (0.00 sec)

------------------------------------------------------------ ---------
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 bugs-thread13694@lists.mysql.com
To unsubscribe, e-mail

Re: estonia charset and upper/lower case (fwd)

Lauri Anton writes:
> Hello!
>
> When I run mysql with default-charset = estonia, it makes difference
> between upper and lower case. With latin1 charset no such distinction are
> made. I think this is a bug. Could someone help me out?
>
> --
> Lauri Anton
> ( anton@EENet.ee )
> ( +3727302126 )
>
>
> How-To-Repeat:
>

Hi!

Changing a charse should make a difference in conversion between upper
and lower case.

Can you give us examples of which Estonians chars are wrongly
converted ???

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
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 bugs-thread13702@lists.mysql.com
To unsubscribe, e-mail

Re: estonia charset and upper/lower case (fwd)

Hello!

On Thu, Feb 06, 2003 at 02:31:46PM +0200, Sinisa Milivojevic wrote:
> >
> > When I run mysql with default-charset = estonia, it makes difference
> > between upper and lower case. With latin1 charset no such distinction are
> > made. I think this is a bug. Could someone help me out?
> >
> > --
> > Lauri Anton
> >
>
> Hi!
>
> Changing a charse should make a difference in conversion between upper
> and lower case.
>
> Can you give us examples of which Estonians chars are wrongly
> converted ???
>
> --
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
> /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com
>

I don't think that there is special problem with Estonian characters. I made
my tests with 'a' and i can repeat that with other chars.

I copied the results of my tests here.

The second test cames from MySQL Language Reference 6.3.2.2 Case-Sensitivity
and the third test comes from 6.3.2.1 String Comparison Functions.


How-To-Repeat:

-------------- charset:estonia -----------------------
Server version: 3.23.49
Client characterset: latin1
Server characterset: estonia

mysql> select * from a where str like 'AAA';
+----+------+
| id | str |
+----+------+
| 1 | AAA |
+----+------+
1 row in set (0.00 sec)

mysql> SELECT "a" = "A";
+-----------+
| "a" = "A" |
+-----------+
| 0 |
+-----------+
1 row in set (0.00 sec)

mysql> SELECT 'abc' LIKE 'ABC';
+------------------+
| 'abc' LIKE 'ABC' |
+------------------+
| 0 |
+------------------+
1 row in set (0.00 sec)

mysql> SELECT 'abc' LIKE BINARY 'ABC';
+-------------------------+
| 'abc' LIKE BINARY 'ABC' |
+-------------------------+
| 0 |
+-------------------------+
1 row in set (0.00 sec)


---------------- charset:latin1 ----------------------
Server version: 3.23.49
Client characterset: latin1
Server characterset: latin1

mysql> select * from a where str like 'AAA';
+----+------+
| id | str |
+----+------+
| 1 | AAA |
| 2 | Aaa |
| 3 | aaa |
+----+------+
3 rows in set (0.00 sec)

mysql> SELECT "a" = "A";
+-----------+
| "a" = "A" |
+-----------+
| 1 |
+-----------+
1 row in set (0.00 sec)

mysql> SELECT 'abc' LIKE 'ABC';
+------------------+
| 'abc' LIKE 'ABC' |
+------------------+
| 1 |
+------------------+
1 row in set (0.00 sec)

mysql> SELECT 'abc' LIKE BINARY 'ABC';
+-------------------------+
| 'abc' LIKE BINARY 'ABC' |
+-------------------------+
| 0 |
+-------------------------+
1 row in set (0.00 sec)

--
Lauri Anton
( anton@EENet.ee )
( +3727302126 )

------------------------------------------------------------ ---------
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 bugs-thread13709@lists.mysql.com
To unsubscribe, e-mail

Re: estonia charset and upper/lower case (fwd)

Lauri Anton writes:
> Hello!
>
> How-To-Repeat:
>
> -------------- charset:estonia -----------------------
> Server version: 3.23.49
> Client characterset: latin1
> Server characterset: estonia
>
> mysql> select * from a where str like 'AAA';
> +----+------+
> | id | str |
> +----+------+
> | 1 | AAA |
> +----+------+
> 1 row in set (0.00 sec)
>
> mysql> SELECT "a" = "A";
> +-----------+
> | "a" = "A" |
> +-----------+
> | 0 |
> +-----------+
> 1 row in set (0.00 sec)
>
> mysql> SELECT 'abc' LIKE 'ABC';
> +------------------+
> | 'abc' LIKE 'ABC' |
> +------------------+
> | 0 |
> +------------------+
> 1 row in set (0.00 sec)
>
> mysql> SELECT 'abc' LIKE BINARY 'ABC';
> +-------------------------+
> | 'abc' LIKE BINARY 'ABC' |
> +-------------------------+
> | 0 |
> +-------------------------+
> 1 row in set (0.00 sec)
>
>
> --
> Lauri Anton
> ( anton@EENet.ee )
> ( +3727302126 )
>

Seems like Estonian charset is broken...

Can you recommend a fix ??

Could you make a better version ??

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
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 bugs-thread13710@lists.mysql.com
To unsubscribe, e-mail