Tag Archives: special characters

Blog: SSIS – Special Characters not processed while reading data from Text File – Fix

I had a scenario wherein special characters (ΓΌ) from text file were not imported properly into SQL Database. Fix is to change the code page from default one (1252) to 65001. New challenge is that destination is not compatible with … Continue reading

Posted in Productivity, SQL Server | Tagged , , , , | Leave a comment

SQL – Remove special Characters from string

I had a requirement to eliminate all the special characters except alphabets and numbers. The traditional way to handle it REPLACE( REPLACE( ‘#My &String’, ‘!’, ” ), ‘#’, ” ) was not helping as I need to list all possible … Continue reading

Posted in Script, SQL, SQL Query, Uncategorized | Tagged , , , , , , , , , , , , | Leave a comment