Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
Hello ,
 
I have a Database instance with collation as 'SQL_Latin1_General_CP1_CI_AS' in SQL server 2008.One table conatins data in greek character set for e.g.
Πριγκηποννήσου
Κομνηνών
Komninon
Διαγόρα
Diagora
Καλλιόπης
Kalliopis
Πάροδος Νίκαιας
Parodos Nikaias
 
Which also give me a problem while searching in sql server. for e.g. select * from tablename where txt like '%μν%'
 
Also in other sql operation it gives issue.
Same issue with Russian language.
 
Do SQL Server 2008 required specific settings for Greek, Russian languages??
 
Please suggest some thoughts on the same.
 
Thanks,
Sachin
Posted 27-Dec-12 0:25am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

your column type should be nvarchar
 
and then
 
search will work this way...
select * from tablename where txt like   N'%μν%'
Happy Coding!
Smile | :)
  Permalink  
Comments
cancerion at 28-Dec-12 4:18am
   
Thanks Aarti
Aarti Meswania at 28-Dec-12 4:19am
   
Welcome :)
Glad to help you! :)
cancerion at 28-Dec-12 6:51am
   
Hi,
Now As my data is stored in NVarchar type column and i can search using N'%μν%'.
Is there any way to convert greek/russian character set to UTF-8 or Simple English character set?
 
Thanks,
Sachin
Aarti Meswania at 28-Dec-12 6:56am
   
no sql will not provide such way
have you tried google translator?
it will allow to convert xls files also
so, you can get data in xls & then translate full data
then import that data in sql
 
Note font of language must be same to google-translator's language font else it will do false conversation

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 403
1 OriginalGriff 354
2 George Jonsson 202
3 Shemeemsha RA 148
4 Animesh Datta 130
0 OriginalGriff 6,189
1 Sergey Alexandrovich Kryukov 5,666
2 CPallini 4,810
3 George Jonsson 3,429
4 Gihan Liyanage 2,522


Advertise | Privacy | Mobile
Web01 | 2.8.140916.1 | Last Updated 27 Dec 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100