CODEWITHSUNDEEP
c#.netsqlsql-server-2005unicode
ediblecode
ediblecode

Reputation: 11971

Convert all unicode characters to a specific character

Is there any way to tell if a character isn't an Extended-ASCII character?

If so, I would like to be able to make that character a '?'

If I tried to insert a Unicode character into a varchar in SQL Server 2005, what would happen?

Thanks.

Upvotes: 0

Views: 187

Answers (1)

Michał Niklas
Michał Niklas

Reputation: 54302

You can create string with all allowable characters (letters, digits, whitespaces, your national accented characters etc) and check every character if it is in this string. If not, then replace it with '?'.

Upvotes: 1

Related Questions