Android Question Special Characters

Erel said:

Local SQLite db? There shouldn't be a problem with saving string with special characters. Post an example if you aren't able to get it working.

Click to expand...

Drop Function If Exists   remover_acentos;

Delimiter |

Create Function fn_remover_acentos( Texto VARCHAR(10000) ) RETURNS VARCHAR(10000)

Begin
    Set @Texto = Texto;

    -- Acentos
    Set @ComAcentos       = 'ŠšŽžÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØÙÚÛÜÝŸÞàáâãäåæçèéêëìíîïñòóôõöøùúûüýÿþƒ';
    Set @SemAcentos       = 'SsZzAAAAAAACEEEEIIIINOOOOOOUUUUYYBaaaaaaaceeeeiiiinoooooouuuuyybf';
    Set @Quantidade       = Length(@ComAcentos);

    While @quantidade > 0 Do
          Set @Texto      = Replace(@Texto, Substring(@ComAcentos, @Quantidade, 1), Substring(@SemAcentos, @Quantidade, 1));
          Set @Quantidade = @Quantidade - 1;
    End While;

    -- Caracteres Especiais
    Set @Especial         = '!@#$%¨&*(^~)_±=§¹²³£¢¬"`´{*Erro*<,>.:;?/°ºª±*|\\';
    Set @Quantidade       = Length(@Especial);
    
    While @Quantidade > 0 Do
          Set @Texto      = Replace(@Texto, Substring(@Especial, @Quantidade, 1), '');
          SET @Quantidade = @Quantidade - 1;
    End While;

    Return @Texto;

End
|
Delimiter ;

Erel said:

The problem is in your MySQL encoding settings. Set it to: utf8mb4
Also set the connection character encoding.

It will work.

Click to expand...

adriano.freitas said:

the best way to encode/decode the string to keep the special characters

Click to expand...

aeric said:

，

Click to expand...

emexes said:

Lol that looks like something that got encoded as UTF-8 and then something like Windows-1252.

Righto, for WIndows-1252:

i with two dots is 207
one-quarter is 188
Πis 140

UTF 207 188 140 decimal is binary 11001111 10111100 10001100

which is looking good so far because the high-bit prefixes are correct for a multibyte encoding

01111 111100 001100 binary = 65292 decimal

Unicode character 65292 is a full-wifth comma

Unicode Decimal Code ，

Code Table - Alt Codes, Ascii Codes, Entities In Html, Unicode Characters, and Unicode Groups and Categories

www.codetable.net

Click to expand...