Click here to Skip to main content
12,898,516 members (67,332 online)
Rate this:
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!
cancerion 28-Dec-12 4:18am
Thanks Aarti
Aarti Meswania 28-Dec-12 4:19am
Welcome :)
Glad to help you! :)
cancerion 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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170424.1 | Last Updated 27 Dec 2012
Copyright © CodeProject, 1999-2017
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