1. A code page is an ordered set of characters, different code page has different set of characters.

2. Better to use unicode if need support multiple languages, and should put N in front of string to insert like N'xxxxx'.

3. Yes but relevant here.