UTF8 conversion to lower - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Transact-SQL (2012)

UTF8 conversion to lower

Author

Topic

Arkala
Starting Member

3 Posts

Posted - 2014-05-08 : 08:01:22

Hi,

I have to convert UTF8 string to upper/lower.

I was trying with below query it is not converting.

select * from GdDirectory where LOWER(FIRST_NAME) = LOWER('Ð¸Ð¼Ñ€Ð°Ð½') COLLATE utf8 --OR UPPER(LAST_NAME) LIKE UPPER('Ð¸Ð¼Ñ€Ð°Ð½')

could any one suggest way to convert UTF8 to upper/lower?

Thanks,
Bhuvana

stepson
Aged Yak Warrior

545 Posts

Posted - 2014-05-08 : 08:15:12

try with N
LOWER(FIRST_NAME) = LOWER(N'Ð¸Ð¼Ñ€Ð°Ð½')

sabinWeb MCP

Arkala
Starting Member

3 Posts

Posted - 2014-05-08 : 08:29:02

Hi ,

I have tried as suggested like,

select * from GdDirectory where LOWER(FIRST_NAME) = LOWER(N'Ð¸Ð¼Ñ€Ð°Ð½') OR LOWER(LAST_NAME) LIKE LOWER(N'Ð¸Ð¼Ñ€Ð°Ð½')

Even this is not giving the results.

Result is same as old one.

Arkala
Starting Member

3 Posts

Posted - 2014-05-21 : 02:50:08

Any more suggestions please for converting utf8 code?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources