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

Making a new Programming Language in a new Character Set in GraalVM

The question is just out of curiosity. Does Graal & Truffle support making a programming language in a new character set? That is, if I want to implement a new programming language in a character set which is neither Unicode nor ASCII, like EBCDIC,…
Jayadevan Vijayan
  • 203
  • 2
  • 9
0
votes
1 answer

Dump and load of MySQL with correct charset/collation

I've a Bamboo build script that shells out to MySQL Admin and does the following: "C:\Program Files\MySQL\MySQL Utilities 1.6\mysqladmin" -f -h server -u user -p pwd drop db1 "C:\Program Files\MySQL\MySQL Utilities 1.6\mysqladmin" -f -h…
Mark Beynon
  • 265
  • 1
  • 3
  • 19
0
votes
2 answers

Invalid utf8 character string. Converting "latin1_german1_ci" column entirely into UTF8

I have a table with a column that has data that seems not to be UTF8. I want to convert that column into UTF8. I found this wonderful tutorial: https://coderwall.com/p/gjyuwg/mysql-convert-encoding-to-utf8-without-garbled-data However, none of these…
Hillcow
  • 890
  • 3
  • 19
  • 48
0
votes
2 answers

HANA: Unknown Characters in Database column of datatype BLOB

I need help on how to resolve characters of unknown type from a database field into a readable format, because I need to overwrite this value on database level with another valid value (in the exact format the application stores it in) to automate…
Laghorn
  • 43
  • 9
0
votes
1 answer

String comparison that ignores special unicode charaters

I have a table with city names in various languages. These names often contain characters such as é, ü etc. I am building a search function so that a user can search for a name, but I would like this to ignore all special characters, and treat them…
Lee White
  • 3,649
  • 8
  • 37
  • 62
0
votes
1 answer

Mysql does not commit changes after setting character set

I am trying to set character set server by using set character_set_server = utf8; (it's originally utf8mb4) after I logged in to MySQL using mysql -u root -p (I also tried another user and also specified a DB with --database). After running the set…
cuneyttyler
  • 1,255
  • 2
  • 17
  • 27
0
votes
0 answers

steps to convert single databse to utf8mb4 in mysql

i want to change the character set of a table in mysql database to utf8mb4 without changing in config file .i dont want entire database to use utf8mb4 . i already changed the database,table and procedures character set and collation to utf8mb4…
user2623775
  • 23
  • 5
0
votes
1 answer

Select returns "¿" character

My query: SELECT op_arv FROM my_table@OTHER_DB returns: d¿identification The "¿" symbol should not be there. If I then run: SELECT substr(op_arv,2,1) AS t_substr ,ascii(substr(op_arv,2,1)) AS t_ascii ,chr(ascii(substr(op_arv,2,1))) AS…
ngundling
  • 17
  • 4
0
votes
1 answer

Character Set Conversion SQL

I have created a database which stores Central European country information. I am having a really hard time making the character set work rightly for these countries because they have so many special characters. I know the "iso-8859-2 Latin 2"…
Jordan Merrill
  • 35
  • 6
0
votes
0 answers

MySQL did not start after setting defaults-file

I am trying to set character_set_server and server_collation to utf8 and utf8_polish_ci to have polish chars in database. I am using MySQL 5.7.10 and as I know I cannot do this after installation. I tried this: mysqld --character-set-server=utf8…
mikroice90
  • 137
  • 1
  • 9
0
votes
0 answers

Translate Selfdrawn Images to Characterset in SublimeText

I want to create a character-set of images that I draw on Adobe Photoshop and view it in Sublime Text. For example, character ᔷ from https://unicode.org/charts/nameslist/n_1400.html#1537 is mapped as (U+1537) and can be copy-pasted into Sublime…
helloOrange
  • 11
  • 3
0
votes
1 answer

MySQL Workbench not respecting configured charset utf8mb4

I've been following this tutorial on how to setup a MySQL server/database for unicode, with the hopes of setting up the default character set to utf8mb4, and the collation to utf8mb4_unicode_ci Just like what is specified in the tutorial, I have the…
contactmatt
  • 18,116
  • 40
  • 128
  • 186
0
votes
1 answer

How to compile an Informix GLS Locale/Character Set. (.lc file into .lco to make an Informix locale for databases)

Overview: I am trying to make my own GLS locale/character set. I am doing this to add it to the locales in my informix instance under GLS/lc11/en_us/myfile.lco so that I can set my database/db locales to the locale I just created. Details: I am…
michael.moyer
  • 88
  • 1
  • 11
0
votes
3 answers

sql: converting from cp1251 to utf8

How to compile a SQL query that converts the table column from cp1251 to utf8. My database and all the tables in it with the encoding of utf8, but the information inside on cp1251. Because of this information is displayed incorrectly. A simple…
Eugene Kotov
  • 1
  • 1
  • 2
0
votes
0 answers

Join tables with different character sets

I am trying to join Table 1 from Database 1 to Table 2 from Database 2. Database 1 and Database 2 have different character sets. When I perform a join, I get the ORA-29275 error (partial multibyte character). I understand that this is due to the…
michal111
  • 400
  • 4
  • 18
1 2 3 4 5 6
7
8