Thank you for your reply. Here is table defination :
SELECT ORDINAL_POSITION, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH
, IS_NULLABLE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'doctormst'
DOCTORMST TABLE STRUCTURE
ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECHARACTER_MAXIMUM_LENGHTIS_NULLABLE
12accodechar8YES
9activechar1YES
6address1varchar40YES
7address2varchar40YES
10degreechar40YES
16DesignationCodechar5YES
1doctorcdchar5No
5doctortypechar2YES
14doctypechar1YES
2firstnamevarchar15YES
18honapplicablechar1YES
4lastnamevarchar15YES
15medicalregnovarchar15YES
3middlenamevarchar15YES
13mobilenochar15YES
8phonevarchar30YES
19tdstypecodechar3YES
11titlevarchar4YES
17WeekApplicablechar1YES
For Unicode :
When he run below queries, there were no output :
select
firstname,lastname,middlename
from
doctormst
where
firstname != cast(firstname as varchar(1000))
select
firstname,lastname,middlename
from
doctormst
where
lastname != cast(lastname as varchar(1000))
select
firstname,lastname,middlename
from
doctormst
where
middlename != cast(middlename as varchar(1000))
So, it means, can we assume that there are no unicode character in these referenced columns please ?
Regards
Girish Sharma