Re: Exporting utf-8 data problems

2006-01-04 Thread mel list_php
y updating to 2.6.4 I've been able to set up the language in phpmyadmin as en-utf-8, and now when I use this interface the data are actually utf8 in the tables. hth, melanie From: Dave M G <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: Re: Exporting utf-8 data problems Date

RE: Exporting utf-8 data problems

2006-01-04 Thread Lopez David E-r9374c
dave I believe group is a reserved word. change to grp. david -Original Message- From: Dave M G [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 04, 2006 8:55 AM To: mysql@lists.mysql.com Subject: Re: Exporting utf-8 data problems Thank you for the advice. In

Re: Exporting utf-8 data problems

2006-01-04 Thread Dave M G
Thank you for the advice. In order to isolate the problem, I have checked to see if the text file that I have exported from the MySQL server on my virtual host is, in fact, in UTF-8. By opening it in OpenOffice and selecting UTF-8 encoding, it displays correctly. N

Re: Exporting utf-8 data problems

2006-01-04 Thread Gleb Paharenko
Hello. >However, when viewing the web pages where content is dynamically called > from the database, all the Japanese text appears on my home machine as >a series of question marks. You should localize the problem. Check with the text editor that files, which you have got from phpMyAdmin r

Re: Exporting utf-8 data problems

2006-01-04 Thread Thomas Spahni
Dave, what is the result of prompt> set | grep LANG ? I suspect your problem is not within MySQL. Did you look at your testfile using a editor? Thomas Spahni On Wed, 4 Jan 2006, Dave M G wrote: > MySQL List, > > I have recently switched over from Windows to Ubuntu Linux, in order to > e

Exporting utf-8 data problems

2006-01-03 Thread Dave M G
MySQL List, I have recently switched over from Windows to Ubuntu Linux, in order to emulate as much as possible the environment I have on my web hosting service. The goal is to be able to develop and test my web sites more completely at home before uploading them. I have successfu