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

MySql INNER JOIN Query issues

I have been searching high and low to a solution for a "stupid" issue i am working with. I have inherited a system from a former developer, and he was using LATIN1 as charset. Not much a problem, BUT i have always used UTF8, and now i need to make a…
Sm00kinG
  • 15
  • 3
0
votes
1 answer

How to save foreign language input in MySQL as it was entered via PHP (currently it is being changed)

Terms in foreign languages (such as French, Chinese, etc.) have been entered into my MySQL table via PHP programs. But when I go to search using this term, it does not find the record. The reason appears to be that the term entered is stored in…
user3624182
  • 1
  • 1
0
votes
0 answers

encoding LATIN1 does not match locale "Spanish_Mexico.1252"; the chosen LC_CTYPE setting requires encoding "WIN1252"

I installed PostgreSQL as part of the OpenGeo Suite and now I need to create a new database with LATIN1 encoding since I need to preserve accents. Problem is that when I try to create the new DB using pgAdminIII, I get an error message telling me…
gallysam
  • 111
  • 3
0
votes
1 answer

MySQL truncates latin-1 data when inserting to UTF-8 column. How to get an error?

Ok, had a problem when I was trying to insert an string that was believed came in UTF-8 format when truly was latin-1. Problem was, behaviour between different servers varied like: Windows will give an error when confronted when a non-UTF8 char:…
paketep
  • 53
  • 6
0
votes
1 answer

PHP/MySQL, discarding Unicode sent from a client

All of our tables are currently set with a LATIN1 character set. A user is currently capable of putting together unicode sequences on the client and trying to embed them into our application. What's the best way to discard all Unicode characters…
randombits
  • 47,058
  • 76
  • 251
  • 433
0
votes
1 answer

Reading from Windows-1252 format from Oracle and Writing to XML file with Latin1 characters UTF-8 encoded

I am trying to read from an oracle db which stores data in Windows-1252 encoding. I am reading that data using jdbc and writing to an xml file with UTF-8 encoding. while writing to these files, I am getting '?' characters instead of the latin…
Sarthak Dudhara
  • 169
  • 17
0
votes
1 answer

Perl (wrong?) encoding of output file

I am running Active Perl 5.16.3 on Windows 7 (32 bits). My (short) program massages an input text file (encoded in UTF-8). I wish the output encoding to be in Latin1, so my code is: open (OUT, '>;encoding(Latin1)', "out.txt") || die "Cannot open…
user3336537
  • 1
0
votes
1 answer

mysql charset latin1 into utf-8 conversion issue

My client's web app has large database which millions of records. All table's encoding is latin1. When I fetch some text field which holds huge data and mail that string some strange haracter issue comes. Such when I recieve email spaces are…
Shahid Karimi
  • 4,096
  • 17
  • 62
  • 104
0
votes
2 answers

Convert mysql query from latin1 to utf8 using nodejs

I have a database in latin1 and I want to convert its queries to utf-8. Example: response.write returns this JSON: {"questions":[{"question":"Nação","answer":"País"}]} But I need it converted to…
ampc
  • 312
  • 1
  • 6
  • 17
0
votes
1 answer

Latin1 character values not displaying the same as in utf8

FOR PYTHON 2.7 (I took a shot of using encode in 3 and am all confused now...would love some advice how to replicate this test in python 3....) For the Euro character (€) I looked up what its utf8 Hex code point was using this tool. It said it was …
user14696
  • 657
  • 2
  • 10
  • 30
0
votes
1 answer

python 2.X and 3.X character encoding difference

When I type the following French character in the Python 2.X interpreter, it gives me a utf-8 byte sequence: >>> x = 'é' >>> x '\xc3\xa9' But same thing on Python 3.X results in following behavior: >>> x = 'é' >>> x 'é' But it is said that default…
user634615
  • 647
  • 7
  • 17
0
votes
1 answer

Change the encoding of a MySQL database

I am having an issue with a MySQL database. I have two copies of it: development and production. Today I realised that: The production database has the encoding format utf8_general_ci The development database has the encoding format…
Miquel
  • 858
  • 11
  • 20
0
votes
1 answer

Python who to write to file encoding 'latin-1'

I know there are many questions out there already concerning encoding/decoding. But this is driving me nuts and I'm in desperate need of some help. I read in a file converting the lines to unicode line = unicode(line,'latin-1') Then, I do some…
LarsVegas
  • 6,522
  • 10
  • 43
  • 67
0
votes
0 answers

How do I convert Latin1 into UTF-8 in XML correctly?

I am using an XML request to send SMS. It has UTF-8 encoding, but my string is in Norwegian. Here part of my string: Trykk på linken for å få In SMS I get this: "Trykk pÃ¥ linken for Ã¥ fÃ¥" But this string is incorrect. I tried to use "Solving…
Denys Medynskyi
  • 2,353
  • 8
  • 39
  • 70
0
votes
1 answer

Convert huge database from Latin1 to UTF8?

We've got a system written in PHP which has grown pretty large over the years. The database is MySQL (InnoDB tables) with currently over 12GB of data, there's hundreds of tables, many of which have over 12 million records! The problem is, a lot of…
BT643
  • 3,495
  • 5
  • 34
  • 55
1 2 3
…
15 16