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
4
votes
2 answers

Why is my View utf8 and how can I change it to latin1

I'm having an issue where a client program needs to use a View, but it needs the results as latin1. Here's what I've got: mysql> show global variables like 'character_set%'; +--------------------------+----------------------------+ | Variable_name …
VenerableAgents
  • 645
  • 1
  • 8
  • 16
4
votes
3 answers

Oracle: Convert xml entities in a varchar2 field to utf-8 characters

I have a field in a table which holds XML entities for special characters, since the table is in latin-1. E.g. "Hallöle slovenčina" (the "ö" is in latin-1, but the "č" in "slovenčina" had to be converted to an entity by some application that…
mawimawi
  • 4,222
  • 3
  • 33
  • 52
4
votes
2 answers

Encoding issue on SQL Server

I'm working with SQL Server database; database instance encoding is "SQL_Latin1_General_CP1_CI_AS". The following code: UPDATE ... SET field = CHAR(136) WHERE... puts in field the following symbol: ˆ But! In Latin1 code table 127-159 codes are…
Nat
  • 467
  • 1
  • 6
  • 12
4
votes
1 answer

MySQL UTF8 Data Not Being Displayed Properly

I want all the data in MySQL to be UTF8 encoded. I've set all the character sets and collations to be UTF8 for the database, tables and columns. Before anything is written to the database, I use mb_detect_encoding in PHP to check if it is UTF8. …
jkharlan
  • 41
  • 1
  • 2
4
votes
2 answers

Perl: String literal in module in latin1 - I want utf8

In the Date::Holidays::DK module, the names of certain Danish holidays are written in Latin1 encoding. For example, January 1st is 'Nytårsdag'. What should I do to $x below in order to get a proper utf8-encoded string? use Date::Holidays::DK; my $x…
Villemoes
  • 216
  • 1
  • 9
4
votes
2 answers

Retrieving latin1 encoded results with JDBC

I am trying to retrieve result sets from a MySQL database sing JDBC which is then used to generate reports in BiRT. The connection string is set up in BiRT. The database is latin1: SHOW VARIABLES LIKE…
LostInTheWoods
  • 51
  • 1
  • 3
4
votes
3 answers

PostgreSQL ignores dashes when ordering

I have a PostgreSQL 8.4 database that is created with the da_DK.utf8 locale. dbname=> show lc_collate; lc_collate ------------ da_DK.utf8 (1 row) When I select something from a table where I order on a character varying column I get a strange…
HakonB
  • 6,977
  • 1
  • 26
  • 27
4
votes
2 answers

problem with unicode decoding

This is funny.. I am trying to read geographic lookup data from openstreetmap. The code that performs the query looks like this params = urllib.urlencode({'q': ",".join([e for e in full_address]), 'format': "json", "addressdetails" : "1"}) query =…
Stefano Borini
  • 138,652
  • 96
  • 297
  • 431
4
votes
4 answers

How to retrieve utf-8 data with php and show the correct encoding in an excelsheet db dump?

Hi I am saving mostly english and german characters into a mysql database which currently is set to utf-8 charset. I am assuming that I should use latin1 charset for this type of data, is that correct? If so how can I change the charset to correct…
mahatmanich
  • 10,791
  • 5
  • 63
  • 82
4
votes
1 answer

Character Encoding From Chinese to Latin1 in Python

I'm trying to convert a localization file that contains Chinese characters such that the chinese characters are converted into latin1 encoding. However, when I run the python script I get this error... UnicodeDecodeError: 'ascii' codec can't decode…
Ricky
  • 181
  • 1
  • 9
4
votes
2 answers

Utf-8 characters displayed as ISO-8859-1

I've got an issue with inserting/reading utf8 content from a db. All verifications I'm doing seem to point to the fact that the content in my DB should be utf8 encoded, however it seems to be latin encoded. The data are initially imported from a PHP…
Max
  • 12,794
  • 30
  • 90
  • 142
4
votes
2 answers

Use latin characters in appengine

How can store latin characters in appengine? (e.g. "peña") when I want to store this I get this error: UnicodeDecodeError: 'ascii' codec can't decode byte 0xf1 in position 2: ordinal not in range(128) I can change the Ñ by N, but, there not another…
Kristian Damian
  • 1,360
  • 3
  • 22
  • 43
4
votes
1 answer

How to detect latin1 and UTF-8?

I am extracting strings from an XML file, and even though it should be pure UTF-8, it is not. My idea was to #!/usr/bin/perl use warnings; use strict; use Encode qw(decode encode); use Data::Dumper; my $x = "m\x{e6}gtig"; my $y =…
Jasmine Lognnes
  • 6,597
  • 9
  • 38
  • 58
4
votes
2 answers

Strip down everything, except alphanumeric and European characters in PHP

I am working on validating my commenting script, and I need to strip down all non-alphanumeric chars except those used in Western Europe. My plan is to regex out all non-alphanumeric characters with: preg_replace("/[^A-Za-z0-9 ]/", '',…
Pringles
  • 4,355
  • 3
  • 18
  • 19
4
votes
1 answer

Can write to stdout using latin-1 encoding but not to a file (Python 2.6)

I have data which is unicode and wish to write it to a file. I am using python 2.6. I am able to print the encoded values but am not able to write it to a file. The default encoding for the environment is UTF-8. Tried using codecs as well, but no…
user1827064
  • 63
  • 2
  • 6
1 2
3
…
15 16