Vadim Chernets's Blog

SQL Unicode characters

Here is small and simple query to check if string contains Unicode characters:

DECLARE @Unicode NVARCHAR(4000), @Regural VARCHAR(4000);

SELECT @Unicode = 'add your string here'

SET @Regural = @Unicode;

IF @Unicode = @Regural

PRINT 'Regural';

ELSE

PRINT 'Unicode';

Comments
BlogCFC was created by Raymond Camden. This blog is running version 5.5.005.


Copyright 2008 © Vadim Chernets. All rights reserved.