Solved

two different collation on latin1 charset

Posted on 2006-07-07
2
833 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 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

860 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