Stack Overflow
Stack Overflow

Questions tagged [latin1]

Latin1 - ISO-8859-1.

A character set defines the way a sequence of bytes is converted into a sequence of characters. This particular character set is known as Latin-1, or ISO-8859-1. Of the 256 characters in Latin-1, 128 are the characters in the ASCII, the characters that typically appear on a standard U.S. English keyboard (and accompanying nonprinting special characters such as ASCII BEL). The remaining 128 consist of special and accented characters that are used regularly in the Western European languages.

To specify these characters in an HTML document (or on StackExchange), you can enter the character entity (if one is defined) or the numeric entity. For example, to cause Æ to appear in a document, you could enter either Æ or &#198. Note that the case of character entities is significant. Specifying æ causes æ to be displayed.

231 questions
0
votes
1 answer

VBA Word - Highlight all non-basic latin characters

I'm trying to write a code that will highlight all non basic latin characters in a Word document (e.g. all characters that are non-alphanumeric, as well as some characters like ".", "(", ")", "?", "/", etc.) This code works but takes way too long…
BiblioPhillip
  • 21
  • 1
  • 4
0
votes
1 answer

Propel / Sybase shows accents as squares

I am using the ORM Propel to interact with my Sybase ASE 15.7 database from a Zend Framework webapp. When I do sp_helpsort my Sybase server seems to be using Latin-1 encoding. I am realising that the accents that are in my database (which shows…
mentinet
  • 744
  • 3
  • 9
  • 23
0
votes
3 answers

Control encoding when parsing SPSS file using package memisc

I have been given a SPSS system file that I would like to analyse using R. I am using the following magic for parsing the file into R. library(memisc) foo <- spss.system.file("foobar.sav") bar <- subset(foo, select=c(var1,var2,var3)) When having a…
Thomas Möbius
  • 1,702
  • 2
  • 17
  • 23
0
votes
2 answers

MySQL convert table to latin1 does not convert foreign characters to correct representation

I have a database that serves a PHP application with non English characters stored in it, for example: ç ã é. Previously, this database had stored and displayed these characters correctly, but after backing it up and restoring, some characters in…
Fábio Antunes
  • 16,984
  • 18
  • 75
  • 96
0
votes
2 answers

How to store characters like ♥☆ to DB?

Previous issue - was not able to store non-english characters: How to store non-english characters? That was fixed by using UTF8. But realized today that symbols like ♥☆ are not stored correctly. They get converted to characters like ♥☆. How can…
Yeti
  • 5,628
  • 9
  • 45
  • 71
0
votes
2 answers

Java: Search in a wrong encoded String without modifying it

I have to find a user-defined String in a Document (using Java), which is stored in a database in a BLOB. When I search a String with special characters ("Umlaute", äöü etc.), it failes, meaning it does not return any positions at all. And I am not…
rGunti
  • 83
  • 1
  • 8
0
votes
2 answers

How to set character_set_results latin1 mysql in Django?

I don't know how to connect to mysql db when db use latin1 encode. What I am try and follow document and I am using mysqlclient==1.3.5 here is my setting for database connection. DATABASES = { 'default': { 'ENGINE':…
giaosudau
  • 2,211
  • 6
  • 33
  • 64
0
votes
0 answers

How to use collation, character_set of connection, database and server to avoid illegal mix of collation error

I have server started with character-set-server=latin1 [mysqld] character-set-server=latin1 The client I am using for connection fires SET NAMES UTF8 As the first query after connection. Database used also uses latin1 charset and collation…
Abhishek
  • 852
  • 9
  • 24
0
votes
3 answers

PHP function unserialize stop working after charset change (from latin1 to UTF-8)

I use the PHP function serialize to serialize an object with a big string, in the string are a special character "—". That object was save when the DB was using latin1 charset now I migrate the db to UTF-8. I use the PHP function unserialize to get…
Tony
  • 287
  • 5
  • 19
0
votes
1 answer

Tokenize latin-1 text in c++

I have mysql table with a latin text. I am trying to tokenize this text into words. I came across boost and ICU tokenizers. The problem is these libraries expects me to figure out the word boundries. I tried following boost code, ( with default…
Icarus3
  • 2,310
  • 14
  • 22
0
votes
1 answer

encoding / decoding special characters in python 2.7

Trying to do some reverse engineering using the Raspberry Pi. I am piping the output of a Can Analyzer to a python script. My main problem is that the 'extended' ascii characters are not displayed correctly in the end. I am running the script as…
Koenieboy
  • 23
  • 1
  • 6
0
votes
0 answers

MySQl - incorrect string value on version from latin1 to utf8

So we originally had latin1 for our MySQL database (a long long time ago) and we are trying to convert to UTF8 before a more global outreach, but I'm having issues with the transition. Here's my MySQL: /* First set as latin1 */ SET NAMES…
Aram Papazian
  • 2,453
  • 6
  • 38
  • 45
0
votes
1 answer

Ruby on Rails 4, incompatible character encodings: latin1

I've a problem with charset encoding/decoding in my web application in rails 4. i see word like "rappresentò" or "è" in my webpage but i want to see "rappresentò" and "è". this is my stack structure : Server Os : Ubuntu 14.04, mysql database :…
user3541704
  • 1
  • 1
0
votes
1 answer

Best way to insert Unicode data to the DB with latin1_general_ci

I receive data from XML file in Unicode. What is the best and correct way to insert/update this data in MySQL DB with fields in latin1_general_ci encoding? Thanks!
Dmytro Zarezenko
  • 10,526
  • 11
  • 62
  • 104
0
votes
1 answer

UTF8 & latin1 Character encoding in mysql 5.1

I'm using PHP Version 5.5.12 & Mysql Version 5.1 . Is the character encoding important in Mysql? Default character encoding in my phpMyAdmin is 'latin1_swedish_ci'. I have some latex and pdf file conversions. I found that Latex would be happy about…
Lucky13
  • 11,393
  • 7
  • 25
  • 36
1 2 3
…
15 16