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
1
vote
1 answer

Converting Composite Bytes to Unicode in MySQL

I have a MySQL database that I recently migrated to another server. Unfortunately, MySQL dumps its data in Latin1 with any UTF-8 characters represented by composite bytes (ex. – instead of —). Is it possible to run a simple query or script that…
Mike Keen
  • 171
  • 1
  • 4
  • 12
1
vote
1 answer

Can someone help me understand why I should or should not convert all my columns from latin1_swedish_ci to utf8_unicode_ci?

I know this has been asked many times, but I'm having a hard time understanding the difference in collation and encoding. OK, so we have a MySQL database (several actually) that have tables with mixed collation. Now, some columns are…
cbmeeks
  • 11,248
  • 22
  • 85
  • 136
1
vote
0 answers

How to fix broken encoded characters in a latin1 encoded column

I have a latin1 table that was filled with different encoded data for a long time so it contains a lot of broken characters. I was trying to fix that and How to detect UTF-8 characters in a Latin1 encoded column - MySQL to be very helpful,…
Clemens Valiente
  • 829
  • 1
  • 8
  • 16
1
vote
3 answers

how to convert é,ê,... in database mysql to the normal string é,â,... using php?

There are the problems of data in mysql. Some data store with the string like (1):"hello & hello ' hello è ...". And some data store with the string like (2):"hello à hello é hello ê ...". I can solve the string (1) to the normal…
Kannika
  • 2,538
  • 2
  • 27
  • 38
1
vote
1 answer

Tornado Lookup Error: unknown encoding: latin1

I'm trying to benchmark a simple Tornado Server made using tornado.httpserver and I get the following error, when using apache bench with 1000 or more concurrent connections on a Solaris machine. Traceback (most recent call last): File…
RickyG
  • 11
  • 3
1
vote
1 answer

Codeigniter error with chatset latin1 (Vbulletin)

i using codeigniter make an project, it as follow. i want to connect to mysql of Vbulletin and show in my project, i save code with UTF-8 not DOM, it show ok but i see at Chrome and IE error HEAD haven't everything. but only TITLE in HEAD and…
tinhphaistc
  • 35
  • 2
  • 11
1
vote
2 answers

API or Method to Replace all non-latin-1 characters

I'm dealing with a 3rd party API / Web Service and they only allow latin-1 character set in their XML. Is there an existing API / method that will find and replace all non-latin-1 characters in a String? For example: Kévin Is there anyway to make…
Gregg
  • 34,973
  • 19
  • 109
  • 214
0
votes
3 answers

UTF8 -> Latin1 Difficulty, PHP

I'm losing accented characters. From PHP I download an xml file which uses UTF8, while my PHP script uses Latin1. I can't manage to convert the UTF8 into Latin1. I've tried…
Alasdair
  • 13,348
  • 18
  • 82
  • 138
0
votes
2 answers

Erlang Emysql encoding difference between prepared and regular Query

I Have wrote a question which got a right answer here about emysql encoding. The answer pinpoint another question... I'm trying to store iPhone emojis into a database... When I do : Query = io_lib:format("UPDATE Users SET c=\"~s\" WHERE id=~B",…
TheSquad
  • 7,385
  • 8
  • 40
  • 79
0
votes
1 answer

Opera and Safari aren't displaying latin1 characters

I'm having trouble displaying latin1 characters such as "ç", "ã" or "À" in the latest versions of Safari and Opera. I receive data (JSON) from a RoR backend using Ajax and JQuery (Latin1 charset) and the webpage itself relies on Latin1, thanks…
João Pereira
  • 3,545
  • 7
  • 44
  • 53
0
votes
2 answers

iPhone NSString comparison having Extended ASCII or Latin 1 Unicode character set

I am having problem with NSString compare. The localizedCaseInsensitiveCompare: or any other compare: method in NSString is returning wrong result to me with extended ascii character set. for example below code, after comparison, noString should be…
karim
  • 15,408
  • 7
  • 58
  • 96
0
votes
2 answers

Detect latin1 characters in utf8 string

I get data from the database that is utf8 encoded. But somehow some old data contains latin1 characters. So this $encod = mb_detect_encoding($string, 'UTF-8', true); always is correct. Is it safe to always use utf8_decode() to check for latin1…
spankmaster79
  • 21,555
  • 10
  • 42
  • 73
0
votes
1 answer

Ruby on Rails - Stripping strange characters out of body in rake task

On my company's Rails website, we have a Twitter area where tweets from our social media team are displayed by a rake task. Basically the rake task uses the Twitter gem to import any new tweets into the database on a regular basis, and displays them…
Shannon
  • 2,744
  • 3
  • 28
  • 37
0
votes
1 answer

PHP question on encoding (latin1_swedish_ci vs utf8_unicode_ci)

I have a question regarding encodings. In my MySQL database I have encoded users in latin1_swedish_ci (bad idea). Now I connect my iPhone application to Facebook and retrieve the list of friend names, and I would like to see if I already have these…
Masiar
  • 20,450
  • 31
  • 97
  • 140
0
votes
1 answer

Converting table from latin1 to UTF-8, key too large problem

I am trying to convert some of my DB tables from latin1 character set to utf-8. Many tables got converted fine, but some tables return this error: alter table xyz convert to CHARACTER SET utf8; ERROR 1118 (42000): Row size too large. The maximum…
Genadinik
  • 18,153
  • 63
  • 185
  • 284
1 2 3
…
15 16