Skip to content

Instantly share code, notes, and snippets.

@renatocfrancisco

renatocfrancisco/sql-tirar-acent.sql

Created August 10, 2022 19:03
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 renatocfrancisco/661bf49ff43af55008c8cadafb681081 to your computer and use it in GitHub Desktop.
Save renatocfrancisco/661bf49ff43af55008c8cadafb681081 to your computer and use it in GitHub Desktop.
Download ZIP
Tirar Acentuação de String SQL
Raw
sql-tirar-acent.sql
-- https://felipelauffer.com/2019/03/01/remover-acentos-e-cedilhas-de-uma-string/
-- Usando COLLATE SQL_Latin, retira acentuação de string
SELECT 'çáéíóúâêîôûãõç' COLLATE SQL_Latin1_General_Cp1251_CS_AS AS nova_string
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment