Solved

two different collation on latin1 charset

Posted on 2006-07-07
2
835 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 14

Accepted Solution

by:
psadac earned 500 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySQL Query Using Up Memory 6 52
I'm getting too many results in this SELECT statement. How can I fix it? 6 67
mysql db 3 82
MySQL Persistent Connections 10 33
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

749 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