Verificar por que en UTF8 para windows no graba en la BD las "Ñ" y acentos
Se cambia la LATIN la base de datos y se corrige
se realizo un funcion para la conversion
public string RemoveAccentsWithRegEx(string inputString) { Regex replace_a_Accents = new Regex("[á|à|ä|â|Á]", RegexOptions.Compiled); Regex replace_e_Accents = new Regex("[é|è|ë|ê|É]", RegexOptions.Compiled); Regex replace_i_Accents = new Regex("[í|ì|ï|î|Í]", RegexOptions.Compiled); Regex replace_o_Accents = new Regex("[ó|ò|ö|ô|Ó]", RegexOptions.Compiled); Regex replace_u_Accents = new Regex("[ú|ù|ü|û|Ú]", RegexOptions.Compiled); Regex replace_n_Accents = new Regex("[ñ|Ñ]", RegexOptions.Compiled); inputString = replace_a_Accents.Replace(inputString, "A"); inputString = replace_e_Accents.Replace(inputString, "E"); inputString = replace_i_Accents.Replace(inputString, "I"); inputString = replace_o_Accents.Replace(inputString, "O"); inputString = replace_u_Accents.Replace(inputString, "U"); inputString = replace_n_Accents.Replace(inputString, "N"); return inputString; }
Esta funcion busca y reemplaza los caracteres extraños
Log in to post a comment.
Se cambia la LATIN la base de datos y se corrige
se realizo un funcion para la conversion
public string RemoveAccentsWithRegEx(string inputString)
{
Regex replace_a_Accents = new Regex("[á|à|ä|â|Á]", RegexOptions.Compiled);
Regex replace_e_Accents = new Regex("[é|è|ë|ê|É]", RegexOptions.Compiled);
Regex replace_i_Accents = new Regex("[í|ì|ï|î|Í]", RegexOptions.Compiled);
Regex replace_o_Accents = new Regex("[ó|ò|ö|ô|Ó]", RegexOptions.Compiled);
Regex replace_u_Accents = new Regex("[ú|ù|ü|û|Ú]", RegexOptions.Compiled);
Regex replace_n_Accents = new Regex("[ñ|Ñ]", RegexOptions.Compiled);
inputString = replace_a_Accents.Replace(inputString, "A");
inputString = replace_e_Accents.Replace(inputString, "E");
inputString = replace_i_Accents.Replace(inputString, "I");
inputString = replace_o_Accents.Replace(inputString, "O");
inputString = replace_u_Accents.Replace(inputString, "U");
inputString = replace_n_Accents.Replace(inputString, "N");
return inputString;
}
Esta funcion busca y reemplaza los caracteres extraños