8 messages in com.mysql.lists.bugsRE: character sets
FromSent OnAttachments
Murat KARABEK08 Feb 2001 06:34 
Thimble Smith08 Feb 2001 06:47 
Murat KARABEK12 Feb 2001 07:52 
Michael Widenius12 Feb 2001 08:25 
Murat KARABEK13 Feb 2001 01:23 
Michael Widenius13 Feb 2001 09:10 
Murat KARABEK13 Feb 2001 23:36 
Michael Widenius14 Feb 2001 01:44 
Subject:RE: character sets
From:Michael Widenius (mon@mysql.com)
Date:02/13/2001 09:10:34 AM
List:com.mysql.lists.bugs

Hi!

"Murat" == Murat KARABEK <mur@mikrobeta.com.tr> writes:

Murat> hi,

Murat> as you said, when i insert new records to the table i get different Murat> ascii values from the values you get.

Murat> in DOS :

Murat> +---------+------------------+ Murat> | field1 | ascii(field1) | Murat> +---------+------------------+ Murat> | ü | 129 | Murat> | ç | 135 | Murat> | s | 159 | Murat> | ö | 148 | Murat> +---------+------------------+

Murat> these are wrong values i think.

This means that you are not using the correct code table on DOS; This isn't a MySQL problem but a DOS problem.

<cut>

Murat> "select field1, upper(field1), ascii(field1) from sample"

Murat> i get this :

Murat> +---------+-------------------+-----------------+ Murat> | field1 | upper(field1) | ascii(field1) | Murat> +---------+-------------------+-----------------+ Murat> | a | A | 97 | Murat> | ç | ç | 231 | Murat> | d | D | 100 | Murat> | e | E | 101 | Murat> | g | g | 240 | Murat> | ö | ö | 246 | Murat> | s | s | 254 | Murat> | t | T | 116 | Murat> | ü | ü | 252 | Murat> | z | Z | 122 | Murat> +---------+-------------------+------------------+

Was the above in does or windows ? (It will not work on DOS)

On Linux I get:

mysql> select field1,ascii(field1),upper(field1),ascii(upper(field1)) from
sample order by field1; +--------+---------------+---------------+----------------------+ | field1 | ascii(field1) | upper(field1) | ascii(upper(field1)) | +--------+---------------+---------------+----------------------+ | a | 97 | A | 65 | | ç | 231 | Ç | 199 | | d | 100 | D | 68 | | g | 103 | G | 71 | | m | 109 | M | 77 | | ö | 246 | Ö | 214 | | s | 115 | S | 83 | | t | 116 | T | 84 | | ü | 252 | Ü | 220 | | x | 120 | X | 88 | +--------+---------------+---------------+----------------------+ 10 rows in set (0.00 sec)

Looks ok to me.

Regards, Monty