There seems to be an issue in regards to ANSI vs Unicode

When the file is viewed as an ANSI encoded file, both chars show

When the file is viewed as an UTF-8 endoded file, only the right char shows....which is the behavior I need

Is there a way to force SQL to write one way or another?