Comments by cancerion

cancerion 28-Dec-12 6:51am View

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

cancerion 28-Dec-12 4:18am View

Thanks Aarti

cancerion 13-Jun-12 2:19am View

Hello,

in a table i have data is utf-8 format for e.g.
Carrer de BÃ©jar
Calle de Antonio Machado
Calle del CanÃ³nigo Domenech
Carrer de Pau ArpÃ i GalÃ
Calle del Abad Oliba

I want them to read in unicode format ,In database in extended property collation is set as 'SQL_Latin1_General_CP1_CI_AS'

Regards,
Sachin

cancerion 12-Jun-12 8:35am View

Thanks for reply..

Actually i am looking for a solution at sql server level,we perform some operation on unicode data. some query to get column values saved in different formats into unicode format.

cancerion 12-Jun-12 8:28am View

Actually in table data can be stored in utf-8 ,ascii ,unicode or any other format , it will not surely in 1 format, so just we want to make sure when retreiving using stored procedure we get in unicode format.

Comments by cancerion (Top 5 by date)