[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

two different collation on latin1 charset

Posted on 2006-07-07
2
Medium Priority
?
861 Views
Last Modified: 2010-08-05
I have a db using charset latin1.

I stored datas full with German chars and Turkish(latin5). I want to sort as the below. Is there any way to use two colaltion table with two different charset...

a
ä
b
c
ç
d
e
.
.
.
.
ı
i
0
Comment
Question by:tolgaong
2 Comments
 
LVL 14

Accepted Solution

by:
psadac earned 1000 total points
ID: 17062447
you can define the charset and collation in your query :

SELECT
  CONVERT(mycol USING latin5) COLLATE latin5_turkish_ci AS mycol_turkish
FROM
  mytable
ORDER BY
  mycol_turkish
0
 
LVL 9

Author Comment

by:tolgaong
ID: 17063915
psadac thanks but it doesnt work.
It gave me the result as

?anl?urfa
for Şanlıurfa and its not in the exact place.

I found a solution with a tricky way. with replacing the chars but i need to know how can we sort by only order by command ?

0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question