Re: collation issues.
Posted by: Rick James
Date: December 19, 2009 09:04PM

Not collation, charset issues.
Your application is using windows-1254; you need to tell MySQL that.
You would need to do
SET NAMES cp1254;
but I don't think that is available in MySQL.

Can you use utf8 instead?

latin5 might work. I don't know if 1254 and latin5 are the same.

Once you establish the right character set, consider using the corresponding collation:
mysql> show collation like '%tur%';
+-------------------+---------+-----+---------+----------+---------+
| Collation         | Charset | Id  | Default | Compiled | Sortlen |
+-------------------+---------+-----+---------+----------+---------+
| latin5_turkish_ci | latin5  |  30 | Yes     |          |       0 |
| utf8_turkish_ci   | utf8    | 201 |         | Yes      |       8 |
| ucs2_turkish_ci   | ucs2    | 137 |         | Yes      |       8 |
+-------------------+---------+-----+---------+----------+---------+

Options: ReplyQuote


Subject
Views
Written By
Posted
3965
December 18, 2009 04:00PM
2176
December 18, 2009 03:58PM
Re: collation issues.
2715
December 19, 2009 09:04PM
2375
December 20, 2009 10:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.