Questions tagged as 'character-encoding'

1
answer

Which encoding to choose for a database?

When we create a new base (regardless of whether it is in MySQL, PostgreSQL, Oracle, SQLServer or other) we can choose which encoding from that database, such as UTF- strong> or Latin-1 . Is there a recommendation or does this make no d...
asked by 12.06.2014 / 20:50
2
answers

What is the difference between charset and collation in database?

Every time I create a database, I always come across these definitions and I do not really know the difference. I understand what is charset , but not collation .     
asked by 26.08.2014 / 16:16
2
answers

Change the collation and character set of the database, tables and corresponding columns

Some older projects were thought of in their immediate purpose and based on this the databases, tables and columns were prepared in a way limited to the intended scenario. In the sense of updating and adapting to a greater scalability of thes...
asked by 28.02.2014 / 22:51
1
answer

Why is the "@" symbol being translated to "¿" when sent via SMS from an Android 2.3 device?

I'm developing an application for Android that sends commands to a remote device via SMS. The commands used are all common text messages, and some of them are started with the prefix [email protected]@ . To test the application I have sent some "commands...
asked by 17.03.2014 / 18:56
3
answers

What is the charset meta in HTML?

Can someone explain this HTML5 code to me? <meta charset="utf-8"> What is the purpose of this standard and why is it used?     
asked by 05.04.2014 / 23:04
2
answers

What are the main differences between Unicode, UTF, ASCII, ANSI?

What are the main differences between "encodings" and "Unicode, UTF, ASCII, ANSI?" Are all of them really encodings or are some just sub-categories of others? I do not want to know all the details of each, just a brief of each and, if poss...
asked by 05.10.2016 / 21:59
3
answers

Problem when using substr in text with PHP

When using substr in a variable with text, it is returning a special character " " could anyone help me? I'm using the following code: $excerpt = get_the_content(); $excerpt = strip_shortcodes($excerpt); $excerpt = strip_tags($excerp...
asked by 06.03.2014 / 14:24
2
answers

What is the difference between varchar and nvarchar?

What's the difference between using data types varchar and nvarchar ? nvarchar exists in every SQL database? Is there any significant difference in performance between the two? Is there a criteria for using them? A...
asked by 21.06.2017 / 15:13
2
answers

Insert with accents in Oracle

When I make a INSERT for example: INSERT INTO TESTE (NOME) VALUES ('INSCRIÇÃO ESTADUAL'); You're saving to the table this way:    STATE ENROLLMENT And the screen displays "INSCRIÃÃO ESTADUAL" . I am using Oracle...
asked by 15.06.2015 / 19:26
1
answer

How to recognize and change the encoding of Latin characters in R?

Is there any efficient way to recognize the encoding of texts downloaded from the internet? I did a scraping of any site (see code below) and I can not find the correct encoding. In the source code META tag the specification is "iso-8859-1" (...
asked by 01.05.2016 / 19:34