Posted by Thang on 09/19/06 10:13

Hi,

See this code:
DECLARE @SQL nvarchar(4000)
SELECT @SQL = 'SELECT * FROM CUSTOMER WHERE CustomerName = N''Trần
Tấn Hận'''
PRINT @SQL

The result always is this:
SELECT * FROM CUSTOMER WHERE CustomerName = N'Tr?n T?n H?n'

• Next in forum: Re: Why cannot set Unicode string
• Prev in forum: Re: How To Select a Certain Limited Number of Rows Per ID
• Thread view: Why cannot set Unicode string

[Reply to this message]