Skip to content

Instantly share code, notes, and snippets.

@tkMageztik

tkMageztik/get_strange_characters_mssql

Created October 20, 2016 20:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tkMageztik/adf28f71a577977276ecbcc4f16bf91d to your computer and use it in GitHub Desktop.
Save tkMageztik/adf28f71a577977276ecbcc4f16bf91d to your computer and use it in GitHub Desktop.
Download ZIP
buscar caracteres extraños incluido caracter nchar(65533) collate latin1_general_BIN2.
Raw
get_strange_characters_mssql
INSERT INTO TMP_CLIENTES
SELECT '',RTRIM(TipDoc),RTRIM(NroDoc),'',RTRIM(NomPrim),RTRIM(NomSeg),RTRIM(ApePri),RTRIM(ApeSeg),'' FROM CLIENTES
WHERE (replace(APEPRI,' ','') like '%[^.ABCDEFGHIJKLMNOPQRSTUVWXYZÑÁÉÍÓÚÜÖ''\-]%'
OR replace(APESEG,' ','') like '%[^.ABCDEFGHIJKLMNOPQRSTUVWXYZÑÁÉÍÓÚÜÖ''\-]%'
OR replace(NOMPRIM,' ','') like '%[^.ABCDEFGHIJKLMNOPQRSTUVWXYZÑÁÉÍÓÚÜÖ''\-]%'
OR replace(NOMSEG,' ','') like '%[^.ABCDEFGHIJKLMNOPQRSTUVWXYZÑÁÉÍÓÚÜÖ''\-]%')
OR CharIndex(nchar(65533) COLLATE Latin1_General_BIN2, APEPRI) > 0
OR CharIndex(nchar(65533) COLLATE Latin1_General_BIN2, APESEG) > 0
OR CharIndex(nchar(65533) COLLATE Latin1_General_BIN2, NOMPRIM) > 0
OR CharIndex(nchar(65533) COLLATE Latin1_General_BIN2, NOMSEG) > 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment