Search the Community
Showing results for tags 'UTF-8'.
Found 4 results
-
My database uses UTF-8 and to create pages from the administrator with fields with special characters (eg é or ñ) are handled smoothly. But in trying to create pages with the API, the values are cut when find the first special character. For example: $ p-> name = "Pedro Pérez"; // With é or $ p-> name = $ sanitizer-> text ("Peter Pérez"); // With é Are recorded "Pedro P" and the rest are lost Any suggestions to resolve the situation?
-
Hi All, After SiNNuT's excellent help in this post: (thank you, SiNNuT), http://processwire.com/talk/topic/5400-tinymce-converting-html-entities-to-characters/ I ran across a new situation -- or more accurately -- a new knowledge gap that I wish I didn't have. I have another PW install, in which the curly quotes are not displaying properly, even though the header includes the line: <meta http-equiv="content-type" content="text/html; charset=utf-8" /> I was digging around, and noticed that I had installed PW into a database that I had created, set to: * charset: latin1 * collation: latin1_swedish_ci instead of utf8 and utf8_general_ci. Now, just to be clear, one of my PW installs with the latin1 charset does display the curly quotes correctly, so I'm not sure why the other install does not. I'm not entirely sure if the db charset and collation are the issue, or something else. And that's an item to solve. But my main questions here are: - Is the issue of installing PW into a latin1 db a huge problem? (It would be really great if the PW install prompted one to make sure that the db had the right charset. Or maybe it did, and I missed it.) - If it is a problem, does anyone have any tips on converting the db, tables and content appropriately? I'm under the impression that one could relatively easily convert the db and tables to utf8, but that the content would have to be converted as well -- perhaps using the PHP inconv function, as Ryan pointed out in another post? $newPage->title = iconv("ISO-8859-1", "UTF-8", $row['HEADLINE']); That sounds like a lot of effort and processing: having to convert every field of every page. As I mentioned, I have one install with latin1 where everything seems to be working okay. So maybe no conversion is necessary. ?? It's that one other install, where the curly quotes aren't showing up in view mode, that has me baffled. What's really weird with that one, is that when I click on edit, either in the admin, or in my front end data form, the typographic curly quotes display correctly. It's only in view mode that they turn into this (in the source), with the page charset set to UTF-8: â��testâ�� the above text should be: “test” (i.e. "test" with curly quotes) By the way, the particular field I'm testing is set to be textarea only -- no TinyMCE at all. => As a related item, the problematic database receives email from a variety of email programs, from both PCs and MACs, and then saves the data to PW. Thus, things like curly quotes could be coming from a variety of machines. My Processwire script to save those pages does not include any type of charset declaration or conversion, because I was under the impression that I didn't need to do that. But that might be another knowledge gap. The test I did above, however, was me pasting in the word "test", with curly quotes, from LibreOffice Writer, on a PC. Thanks for all the help! I do intend to one day answer some questions myself, when I become more proficient in PW. (Well, I have posted one Case Study, so far.) Peter -
Hello, I have pretty strange situation. Hosting that I'm working on is forcing ISO-8859-2 encoding. I don't have any real access to it, just ftp to folder where I'm installing a site. None of htaccess solutions worked - have no idea why. The only thing that worked for me was adding header("Content-Type: text/html;charset=UTF-8"); to every template. But ProcessWire backend is still encoded in ISO-8859-2 and messy. How to write module that would add it to every ProcessWire pageload? Or to which PW file and where I need to paste it (probably it will never be updated)? My php skills are really poor. Know only basics that allow me to ingrate processwire to site.
-
Hello, i need to import a large number of articles from an old site into my PW project. So I wrote an import script which gets the data and for each row, creates a new page in PW and inserts it. So far, so easy. Problems arise because the old DB is latin-1 encoded and I keep getting strange results which are probably due to character encoding. $con = mysql_connect("localhost","yes","also"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_set_charset("latin1", $con); mysql_select_db("mtb", $con); $result = mysql_query('SELECT * FROM stuff'); while($row = mysql_fetch_array($result)) { $new = new Page(); $new->of(false); $new->template = wire('templates')->get('article'); $new->parent = wire('pages')->get('/news/'); $name = wire('sanitizer')->pageName(utf8_encode($row['HEADLINE'])); [*]$new_name = $name; $i = 1; while(isset($found{$new_name})) { error_log('DOPPLER! '.$new_name); $new_name = $name.'-'.$i; $i++; } $found{$new_name} = 1; } Even though I check for double page names, I keep getting the 'Duplicate entry' error. I also tried while(wire('pages')->get("name=$new_name,template=article")->id) {} to find duplicates but it stops with 'Duplicate entry' at a different data set ...I'm confused ... can anyone help? Thanks, thomas
