[SQL Server] Enlever les accents dans une chaîne de caractère

-- =============================================

-- Author     : KHARROUBI Zouhaier

-- Create date: 25/04/2014

-- Description: Enlever les accents dans une chaine de caractère

-- =============================================

 

SELECT CAST(N'úüáéèíóû' AS VARCHAR(MAX)) COLLATE SQL_Latin1_General_Cp1251_CS_AS AS RESULTAT

Résultat :

enlever accents

Commentaires   

0 #2 Sabina 16-07-2017 01:52
Hello fellas! Who wants to see me live? I'm live at HotBabesCams.com, we can chat, you can watch me live for free,
my nickname is Anemonalove: https://3.bp.blogspot.com/-u5pGYuGNsSo/WVixiO8RBUI/AAAAAAAAAFA/JWa2LHHFI2AkHParQa3fwwHhVijolmq8QCLcBGAs/s1600/hottest%2Bwebcam%2Bgirl%2B-%2BAnemonalove.jpg , here
is my pic:

https://3.bp.blogspot.com/-u5pGYuGNsSo/WVixiO8RBUI/AAAAAAAAAFA/JWa2LHHFI2AkHParQa3fwwHhVijolmq8QCLcBGAs/s1600/hottest%2Bwebcam%2Bgirl%2B-%2BAnemonalove.jpg
Citer
0 #1 Rita 05-07-2017 04:21
Hello fellas! Who wants to meet me? I have profile at hotbabescams.com, we can chat,
you can watch me live for free, my nickname is Anemonalove: http://hotbabescams.com , here is my photo:

https://3.bp.blogspot.com/-u5pGYuGNsSo/WVixiO8RBUI/AAAAAAAAAFA/JWa2LHHFI2AkHParQa3fwwHhVijolmq8QCLcBGAs/s1600/hottest%2Bwebcam%2Bgirl%2B-%2BAnemonalove.jpg
Citer

Ajouter un Commentaire


Code de sécurité
Rafraîchir