Sunday, June 30, 2013

How to get ASCII values for THAI Characters using T SQL ??

It works for me correctly with Windows 7 (USA) and SQL Server 2012:



DECLARE @thai nvarchar(max) = N'มหัพภาค';

SELECT @thai;
-- มหัพภาค

SELECT UNICODE (LEFT (@thai, 1));
-- 3617





Kalman Toth Database & OLAP Architect sqlusa.com

New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012


No comments:

Post a Comment