-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: Star_Venkat
Message 1 in Discussion
Learn about Unicode functionality: Unicode will returns an integer value for
the appropriate mapped character.
If we try to do the same on the string, Unicode for the first character of the
string will be considered.
The syntax is,
UNICODE('CHARACTER EXPRESSION')
Example:
DECLARE @Venkistring nchar(12)
SET @Venkistring = N'HCLVenkat'
select @Venkistring
SELECT UNICODE(@Venkistring), NCHAR(UNICODE(@Venkistring))
In the above example, am declaring a string for that i have set the values, on
putting unicode on that particular string the first character of that string
will be retrieved and unicode for that particular character will be retrieved
off.
Scenarios used: In case of encrypting the datas we are in use of this Unicodes.
Regards,
Venkatesan Prabu. J
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
