Click here to Skip to main content
Rate this: bad
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.
Πάροδος Νίκαιας
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.
Posted 27-Dec-12 0:25am

1 solution

Rate this: bad
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 | :)
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
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?
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