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

Converting string unicode to latin

I have the following result from some http requests: Tratamento\ da\ rejei\u00E7\u00E3o\ no\ cancelamento\ da\ desagrega\u00E7\u00E3o i did some research and i was able to find this line of code, wich can convert utf-16 with the following line of…
thclpr
  • 5,778
  • 10
  • 54
  • 87
0
votes
1 answer

Import sql as latin-1

I have an existing sql file which I want to import into a MySQL database 5.5 After import I do an: SELECT * FROM address; and instead of 'Straße' I get 'Straße' The import command is: mysql -uroot store < C:\PathTo\store.sql Using phpMyAdmin I…
My-Name-Is
  • 4,814
  • 10
  • 44
  • 84
0
votes
2 answers

Converting a database from one character encoding to another

I have a MYSQL database. Text is currently stored in charset latin1, collation latin1_swedish_ci. These are the defaults and it wasn't a problem back in the day when the database was originally created. I want to switch over to UTF8 so the text…
Rik Heywood
  • 13,816
  • 9
  • 61
  • 81
0
votes
0 answers

Strange characters after inserting string from utf8_decode into a mysql table with PHP 5.3/Doctrine 1.2

I'm consuming a xml (i get it by a rest service). At one point i decode a CDATA field as: $version_doc = $this->getSimpleXml($uri); if($version_doc != false){ $equipment = utf8_decode((string)$version_doc->equipment); } This is an example…
R01010010
  • 5,670
  • 11
  • 47
  • 77
0
votes
1 answer

PHP charset conversion

I had previously encoded MySQL data in latin1. Now, I've converted it to UTF-8 in MySQL but the data is still saved in latin1. UTF-8 data that was originally stored as Latin-1 has not converted correctly to UTF-8. I need a work around in PHP, so…
Haroon
  • 155
  • 2
  • 10
0
votes
1 answer

Upgrading Rails 3 app from Ruby 1.8.7 to 1.9.3 stops respecting latin1 encoding specification in database.yml

I'm upgrading a Rails 3.2.13 application from Ruby 1.8.7-p370 to Ruby 1.9.3-p385. After upgrading, special characters are garbled in text retrieved from the database. For instance "café" appears as "café". My database is latin1 encoded. I'm using…
hoffm
  • 2,386
  • 23
  • 36
0
votes
1 answer

Display latin character in html

I have a PHP object displaying values as below when I use var_dump($obj): object() (1) { ["name"]=> string(3) "Lê" ... } But when I print $obj->name, the browser displays "Lê" instead. My browser is displaying UTF-8. HTML charset is also set to…
Duc Le
  • 347
  • 1
  • 7
  • 12
0
votes
3 answers

Django Latin Characters do not work

I'm trying to solve this issue when importing a CSV file. I try to save a string variable that contains latin-1 characters and when I try to print them, it changes it to an encoding. Is there anything I can do to keep the encoding? I simply want to…
Marco A
  • 109
  • 1
  • 2
  • 10
0
votes
1 answer

Extended charsets chars not reccognized and converting to ? mark

I have a string contain some special char like "\u2012" i.e. FIGURE DASH. When i am trying to print this on console I am getting a '?' mark instead of its symbol. I have an editor where in I can insert the symbol using alt+numpad like alt+2012. In…
Vix
  • 63
  • 7
0
votes
1 answer

How to deal with legacy app storing Arabian characters in latin1 database

I now work on a web-base PHP app to work with a MySQL Server database . database is with Latin1 Character set and all Persian texts don't show properly . database is used with a windows software Show and Save Persian texts good . I don't want to…
Root
  • 2,269
  • 5
  • 29
  • 58
0
votes
1 answer

Character encoding issues with MySQL - Collation set to UTF-8, but text stored as ISO Latin 1

I have a table for which the collation is set to ut8_general_ci. The columns in the table are also set to this encoding. For some reason though, when I view my table in MySQL the text in the table is rendered/stored as ISO Latin 1, and if I wan't…
Nick
  • 4,304
  • 15
  • 69
  • 108
0
votes
1 answer

How to convert old database in mysql form latin1 to utf8

I have a database in latin1 format, all the utf8 character stored are shown as ???? +------+---------+-------+---------+--------------------+----------+-------------------- -----+---------------------+---------------------+---------+ | id …
Abhay Kumar
  • 1,582
  • 1
  • 19
  • 45
0
votes
0 answers

After migrating db php returns latin1 charset, but in DB - cp1251

I need to transfer my mysql DB from windows server to Ubuntu server. So i made export in phpmyadmin on win and imported *.sql file in linux. In linux PMA all looks okay, tables are healthy, no errors, and charter set is (cp1251), russian data in…
Sergii Rechmp
  • 309
  • 1
  • 6
  • 16
0
votes
1 answer

understanding file encodings

in eclipse, I have a file where some place this is written: onclick='obj1.help_open_new_window(fn1(), "/redir/url_name")' and in eclipse Edit menu->set encoding, I see this: Now I change the encoding to UTF-8 using the same dialog box and the…
prongs
  • 9,422
  • 21
  • 67
  • 105
-1
votes
3 answers

converting "????" in mysql to something readable?

We've got a situation where several months of data that was collected via ODK Aggregate into a MySQL database is unreadable. Data is Georgian characters, but was sent to a database with a latin1 character set/collation. Data managers didn't catch…
David
  • 68
  • 1
  • 7
1 2 3
…
15
16