Stack Overflow
Stack Overflow

Questions tagged [character-set]

A character set maps a set of characters to specific numeric values, e.g. ASCII, UTF-8 and ISO-8859-1.

A character set maps a set of characters to specific numeric values.

Modern computer languages, editors and tools facilitate encoding and decoding of data between internal representations of data and specific character sets. Examples include ASCII, UTF-8 and ISO-8859-1.

Consideration should be given to using the appropriate character set for transmission and persistence of data, particularly text that can contain special characters (such as European languages like French or German) or be in a completely different script (such as Japanese) - see internationalisation (also referred to as i18n).

120 questions
0
votes
1 answer

Show entity definitions inside title of divs

Having this HTML block in a React app:
{myValue}
The content of myValue is MyCompany™. The inner div is showing the content correctly. But the title, which appears when hover, replaces…
Jean Pierre
  • 281
  • 8
  • 21
0
votes
1 answer

Mysql: Set collation for view not working

I want to set the collation of a view to default database. But the option is not available. Even if I try to set anything other than that, the same is not reflected at columns as individually they have different collation. Code: create or replace…
Jake
  • 391
  • 1
  • 4
  • 22
0
votes
0 answers

file encoding to utf-8 from iso-8859

input file with 50k plus unix file command shows it as ISO-8859 text, with very long lines input record causing issue MONTRéAL when i use iconv command like below nothing changes, record is as-is **iconv -f ISO-8859-1 -t UTF-8 input.txt -o…
Krrp78
  • 1
0
votes
0 answers

Incorrect string value: '\xF0\x9F\x98\xA0",...' for column 'properties' error in MySQL Events data

I know there are a bunch of posts relating to this issue. But nothing worked for me. The issue is I get this error when I insert events data into mysql table. This error specifically comes due to properties column which is of JSON type. I know this…
SHOAIB AHMED
  • 1
  • 7
0
votes
2 answers

Limiting textField length depending on what characters are entered into it?

I've got this textfield function that limits the length to 3. One of the two text fields this goes to allows a minus sign "-". If I type numerals with the numberpad they stop at 3 characters. If I type a "-" with numerals behind it, they stop at 3…
user14108256
0
votes
3 answers

Strip non English characters in Oracle SQL

I'm working on a system that records persons names. We need to strip accents from the names to suit legacy systems. One such fictionalised example is RÃOUL TÉLITINO and we need to convert à to A and É to E and so forth.   I'm having difficulty doing…
Nimbocrux
  • 509
  • 2
  • 10
  • 27
0
votes
1 answer

What is the priority of mysql character set?

You can check the character set of show create table 'table', show create database 'database', \s with db, table, system. What character set does this table use if the situation is as below? If the client is utf8mb4 and the table is utf8mb4, there…
user1819769
  • 85
  • 7
0
votes
0 answers

ActiveMQ - override default CharacterSet

Is there a way to override the default CharacterSet and explicitly set it as UTF-8 in the ActiveMQ config (xml) or through a startup parameter?
Suresh Thomas
  • 1
0
votes
1 answer

Mysql8 :What character set should the server translate statements to after receiving them when using introducer?

According to the MYSQL8 docs: Several questions about character set and collation handling for client connections can be answered in terms of system variables: What character set are statements in when they leave the client? The server takes the…
Jinke2017
  • 49
  • 6
0
votes
1 answer

snowflake: Converting Encoding of field to UTF8

I have a field from source which is having HTML encoding character, I have to load data in UTF8 format. As example: data from source is "VE-S&P Global Blue Coat Replacement" Data in Target required to be store as "VE-S&P Global Blue Coat…
Poonam
  • 1
  • 1
0
votes
3 answers

JAVA to EBCIDIC Conversion is not happening

I am trying to get data from one application and send that to another(mainframe) after processing the data. Lets assume I am getting data as "This is from another application", processed the same and processing status as "This data is processed".…
codetaker
  • 21
  • 1
  • 5
0
votes
1 answer

MYSQL: Strings in DDL of VIEW turned into garbled symbols several hours later

I recently modified the DDL of a VIEW with Workbench by adding a filter with strings of Chinese characters. The DDL can be saved successfully and worked perfectly right after being modified. However, the modification itself in the DDL became garbled…
Henry Tsai
  • 21
  • 2
0
votes
0 answers

COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4'

I got very wierd error when I query from tbl_class table. COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' here is the query SELECT CONCAT(SUBSTRING_INDEX(ac.class_group_name, ';', 1), '/'), ac.class_upper_class_id INTO…
bucky2
  • 53
  • 1
  • 5
0
votes
0 answers

Line Feed not transmitted to Oracle with Attunity driver on SSIS

I'd like to load data from Azure to an oracle database through SSIS with an Attunity driver. Now I've noticed that the character "Line Feed" (Ascii 10) is not inserted. When I do the same with an oledb driver instead of Attunity as destination, the…
Swiss_BI
  • 1
0
votes
2 answers

NLS_CHARACTERSET in nls_session_parameters returns None

An application I'm using with Oracle seems to be having issues with characters, and I ran the queries below to check on the CHARACTERSET. SELECT * FROM nls_session_parameters WHERE PARAMETER='NLS_CHARACTERSET'; SELECT * FROM nls_database_parameters…
Sattesh Maran
  • 11
  • 1
  • 3
1 2 3 4 5
6
7 8