| | |
| |||||||
| Forums | Register | Groups | Awards | Arcade | Pets | T-Bucks / T-Store | Invite Your Friends | All Albums | Projects | Blogs | Mark Forums Read |
| Web Design Forums and discussions on webdesign |
 Web Design | |||||||||
|
|
|
|
| |||||
 |
| | LinkBack | Thread Tools |
03-29-2005, 08:00
| #1 (permalink) |
| Civilians |  Character encoding I'm redevloping one of my sites which will contain things like french characters ... So, what should I set my MySQL database to? For some reason, my newly setup localhost databases set the collation to latin1_swedish_ci, however I have manually set this to utf8_general_ci on the tables. The database looks like it's holding the characters fine, so it must be the header in my document. I'm not so much involved with front end devlopment, so the CSS stuff isn't something that I work on, any help appreciated .. here's my header ... <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en-GB"> At the moment these characters are coming out as '?' and the w3 validator fails. Should I consider using charset iso-8859-1 instead of UTF-8? " The Unicode Byte-Order Mark (BOM) in UTF-8 encoded files is known to cause problems for some text editors and older browsers. You may want to consider avoiding its use until it is better supported. Sorry, I am unable to validate this document because on lines 78, 84 it contained one or more bytes that I cannot interpret as utf-8 (in other words, the bytes found are not valid values in the specified Character Encoding). Please check both the content of the file and the character encoding indication. " Thanks |
     |
| Trackpads Information |
| |
|
03-29-2005, 08:00
| #3 (permalink) |
| Civilians | Re: Character encoding elyob wrote: >Forgot to add this part of my header ... > > <meta http-equiv="content-type" content="application/xhtml+xml; >charset=UTF-8" /> > > > > > French can use other character encding than UTF-8 which is more suitable for asian languages. Use your own (french) encoding both in your tables and into your pages. -- Jorj Moderator SEO forum http://forum.bitcontent.com Webmaster community focusing on Internet marketing and website development issues -- |
| |
|
03-29-2005, 12:00
| #4 (permalink) |
| Civilians | Re: Character encoding And lo, elyob didst speak in alt.www.webmaster: > For some reason, > my newly setup localhost databases set the collation to > latin1_swedish_ci, > however I have manually set this to utf8_general_ci on the tables. The > database looks like it's holding the characters fine, so it must be the > header in my document. There is no need to change the character encoding of your MySQL tables unless you plan to do some encoding specific operations on the data. latin1_swedish_ci is perfectly capable of storing and delivering UTF-8 encoded characters in their component bits. As long as your input pages are UTF-8 encoded and your output pages are UTF-8 encoded, the characters will display fine using the latin1_swedish_ci table charset. Grey -- The technical axiom that nothing is impossible sinisterly implies the pitfall corollory that nothing is ridiculous. - http://www.greywyvern.com/ringmaker - Orca Ringmaker: Host a web ring from your website! |
| |
|
03-29-2005, 12:00
| #6 (permalink) |
| Civilians | Re: Character encoding MGW wrote: > So what's the best encoding to use if a site only has English? ISO-8859-1 -- Dylan Parry http://webpageworkshop.co.uk -- FREE Web tutorials and references |
| |
|
03-29-2005, 16:00
| #7 (permalink) |
| Civilians | Re: Character encoding Dylan Parry usenet@dylanparry.com wrote: > MGW wrote: > > So what's the best encoding to use if a site only has English? > > ISO-8859-1 > Which is also perfectly acceptable for a site that is in Engliah and French. It covers all the Latin languages. -- eric www.ericjarvis.co.uk "live fast, die only if strictly necessary" |
| |
|
| Bookmarks |
| Thread Tools | |
| |
|
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Character encoding failes. | Wim Cossement | Web Design | 1 | 02-23-2005 12:00 |
| character encoding? | T.J. | Web Design | 5 | 01-24-2005 00:00 |
| Encoding on PocketPC? | Matija | Microsoft Applications | 1 | 07-24-2004 00:07 |
| Cyrillic encoding in Powerpoint 97 | Microsoft Applications | 1 | 07-10-2004 08:00 | |
| HTML source encoding! | Ammar | Web Design | 4 | 06-15-2004 12:01 |
 |  |  |
